2 ms·
You are right. But "hundreds of queries a second" are fine if there're mostly _read_ queries. http://www.sqlite.org/faq.html#q5 http://www.sqlite.org/faq.html#
by ash 18y ago
You are right. But "hundreds of queries a second" are fine if there're mostly _read_ queries.
http://www.sqlite.org/faq.html#q5 http://www.sqlite.org/faq.html#q5
- ashleyw 18y agoYeh I should have mentioned the times I've used SQLite was early in development, or one time when I created a script which would pump tons of data into the database in threads, which resulted in errors and missing data. I'm sure I could have added better error exceptions and keep retrying, but if you translate that to a multi-user app, thats just not going to cut it. A quick change to MySQL fixed it. :) I do like SQLite, just not for anything where you cant control the writes per second, or need it to be high.