+ 1

Can I use Sqlite3 for a site that performs more than 2,500 insert queries a day?

Can Sqlite3 perform more than 2,500 insert queries a day.

28th Jul 2021, 1:15 PM
Chim - avatar
2 Answers
+ 7
That kind of speeds depends on how large your DB is and how much data you are inserting per query, as well as what hardware you are running. Regardless, we usually wonder if we can perform 2500 inserts per second, not per day. https://www.sqlite.org/speed.html
28th Jul 2021, 1:24 PM
Hatsy Rei
Hatsy Rei - avatar
+ 6
Prince Chimaokwu Generally speaking, 2,500 inserts (and/or queries) per day is a tiny amount of work on any database and shouldn't be an issue with SQLite. The decision on which database to use will not be impacted solely on the number of inserts per day. Without a more complete picture of the context and expected usage scenarios for this database, it's difficult to advise on whether or not you have other factors to consider. Assuming the usage scenario is super basic, you should be fine.
28th Jul 2021, 7:04 PM
David Carroll
David Carroll - avatar