You may use EXPLAIN clause and verify the reazon...
Cláudio
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
"Se você nunca abriu mão de algo pelos seus ideais, provavelmente não tem
nenhum ideal."
Cláudio Bezerra Leopoldino
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Profissional: [EMAIL PROTECTED]
Acadêmico: [EMAIL PROTECTED]
Piadas e Afins: [EMAIL PROTECTED]
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
____________________________________________________
Yahoo! Mail, cada vez melhor: agora com 1GB de espaço grátis!
http://mail.yahoo.com.br