News for hackers. Stuff that matters.
Re:Why SQLite is so great for the edge by norir on Tuesday June 06, 2023 @02:46PM (#36217314)
I'm pretty sure sqlite is capable of significantly higher throughput that 10-20k rows per second depending on the workload. Inserts can be much faster if they are batched in large transactions and prepared statements are used to avoid sql parsing for each row. This only works of course if your workload can be batched.

There are no comments on this comment yet.