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]



Reply via email to