Hannes Roth wrote:
2. Why is SQLite twice as fast when using a small database (<3000 rows)
and twice as slow when using a large database (>8000 rows)?
The speed comparison at http://www.sqlite.org/speed.html uses tables
with 25000 rows and is twice as fast as MySQL. I don't know why yours
is slower - you did not give much data to go on. Perhaps if you
supplied some information about your database (the schema, what
indices are defined, what data is being stored, what your queries
look like) someone could better answer your question.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]