On 7/17/06, Sripathi Raj <[EMAIL PROTECTED]> wrote:
Hi,
I read in one of the threads that count(*) has to be hand optimized since
SQLite doesn't optimize it. Any pointers on how to do that?
When doing joins put the table that contributes the smallest number of
rows to the result set as the first table.
Don't use inexact comparisons in the where clause (like and not equal and such)
the explain option in the command helps you compare different
statements and how they are executed
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite
Cthulhu Bucks!
http://www.cthulhubucks.com
