Jakub
D. Richard Hipp wrote:
Christopher Petrilli wrote:
Has anyone had any experience in storing a million or more rows in a
SQLite3 database? I've got a database that I've been building, which
gets 250 inserts/second, roughly, and which has about 3M rows in it. At that point, the CPU load is huge.
Note that I've got syncing turned off, because I'm willing to accept the risks.
I've been running some tests. I find that INSERTs (into a table with 5 indices) are 3.5 times faster if you put them inside BEGIN...COMMIT rather than turning off syncing.
