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. Thoughts? Chris -- | Christopher Petrilli | [EMAIL PROTECTED]
