On Fri, 09 Jan 2009 21:16:03 +0100, Lukas Haase
<[email protected]> wrote in General Discussion of SQLite
Database <[email protected]>:
>Hello Richard!
>
>Thank you very much!! It works! :-)
>
>
>Indeed. 0-10 milliseconds instead of 500-800 :-)
>
>But may you tell me why this works and where you have this information?
>I know the O-notation but I do not know /why/ this boosts down to log(n)...
Use EXPLAIN SELECT .....
to see the virtual machine instructions
and EXPLAIN SELECT QUERY PLAN .....
to see which index is used.
http://www.sqlite.org/lang_explain.html
Each JOIN is implemented as nested loops. The virtual
machine code can tell a lot about what part of the database
has to be scanned.
>I have other queries which worry me. But that trick did not help in
>these cases :-(
>
[...]
>
>Thank you again and best regards,
>Luke
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
