[sqlite] Newbie sql: query and joining more than two tables

[Karim Ryde]

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