Hi! I hope to get some feedback whether the query time is what I should expect. Running this query below takes several seconds - typically 1-3s.
SELECT package.id, package.name, package.description, package.size, package.latest, version.version FROM category, package, version WHERE package.idCategory = category.id AND category.name = '" + category + "'" AND version.idPackage = package.id " ORDER BY lower( package.name ); The three tables are like this: CREATE TABLE category ( id INTEGER UNIQUE, name VARCHAR(32) ); CREATE INDEX index_name ON category ( name ); CREATE TABLE package ( id INTEGER UNIQUE, idCategory INTEGER, name VARCHAR(32), latest VARCHAR(32), description VARCHAR(255), size VARCHAR(32), keyword VARCHAR(32)); CREATE INDEX index_name ON package ( name ); CREATE TABLE version ( id INTEGER UNIQUE, idPackage INTEGER, version VARCHAR(32), date VARCHAR(32)); The table category has 136 rows, package 9379 rows and version 19369 rows. Regards, /Karim