Martin Gagnon wrote:
Hi all,
Using sqlite3 on QNX 6.3.0.
I need to do a select query on 3 tables by binding them by their ID's.
Something like:
Select tbl1.ID, tbl1.fld1, tbl1.fld2 /*(15 fields total, all from
tbl1)*/ from tbl1, tbl2, tbl3, where tbl1.ID=4 AND tbl1.ID=tbl2.ParentID
AND tbl2.ID=tbl3.ParentID
This returns the expected row instantly but the sqlite3 process takes
more that 10 seconds to give back a prompt, taking all the CPU time.
Is there a way to accomplish this task better?
Thank you,
Martin Gagnon
Martin,
Pardon me if I missed something, but if your query only returns fields
from table tbl1 (as it says in your comment), why do you need to join
with the other tables? Your query doesn't reference fields from the
other tables in where clauses that might restrict the rows that are
returned, it only gives the join conditions. From what you have said,
this should equivalent to your query;
Select tbl1.ID, tbl1.fld1, tbl1.fld2 /*(15 fields total, all from
tbl1)*/ from tbl1 where tbl1.ID=4
Dennis Cote
