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.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
