Optimize sqlite queries in zxtune-android online sources cache databases

[Vitamin Vitamin]

CREATE TABLE xxx_yyys (hash INTEGER UNIQUE , xxx_id INTEGER, yyy_id INTEGER); INSERT INTO xxx_yyys VALUES (hash=NUM*xxx+yyy, xxx, yyy); SELECT yyy_id from xxx_yyys where xxx_id = xxx;

should be replaced with:

CREATE TABLE xxx_yyys (_id INTEGER PRIMARY KEY, yyy_id INTEGER); INSERT INTO xxx_yyys VALUES(_id=NUMxxx+yyy, yyy); SELECT yyy_id from xxx_yyys where _id between NUMxxx and NUM*(xxx+1)-1;

using null yyy_id as a cache mark.

[Vitamin Vitamin]

Fixed in e133b59