On Tue, 14 Dec 2004, 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.
Thoughts?
Chris
-- | Christopher Petrilli | [EMAIL PROTECTED]
on linux perhaps?
cp ./db /dev/shm && a.out /dev/shm/db && mv /dev/shm/db ./db
this will be fast.
are you sure it's not YOUR 'building' code which is killing the cpu? can you gperf it?
-a -- =============================================================================== | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE :: 303.497.6469 | When you do something, you should burn yourself completely, like a good | bonfire, leaving no trace of yourself. --Shunryu Suzuki ===============================================================================
