I've used it a fair bit. My biggest use was for a computer processing system that recorded gigabytes of data. If it was limited to 60 inserts per second it would have taken months to run!
I do recall having to change some settings to make it really fast, but it wasn't 60/second slow.
SQLite is really fast. There's no way that's the bottleneck.
What’s your experience with SQLite? It’s a bit hard to talk about performance without sharing code.
I've used it a fair bit. My biggest use was for a computer processing system that recorded gigabytes of data. If it was limited to 60 inserts per second it would have taken months to run!
I do recall having to change some settings to make it really fast, but it wasn't 60/second slow.
See the "update" in this answer.
https://www.sqlite.org/faq.html#q19
1 reply →