El 24-03-2006, a las 16:08, [EMAIL PROTECTED] escribió:
Elcin Recebli <[EMAIL PROTECTED]> wrote:
Hi.
You're joining the table with itself using 'id'. However, there's
no index just on that field. I'm not sure how exactly SQLite
utilises indices, but it might be unable to use index on
(id,key,source) triple to optimise calculation of "m1.id = m2.id".
SQLite is able to use the prefix of an index. So in
this case, the index on (id,key,source) would be used
to optimize m1.id=m2.id.
Hello,
Well it definitly did something. The query execution time was down by
a factor of at least 100.
Thanks Elcin.
-- Tobias
