Jeremy Hinegardner wrote: > ./sqlite_insert 100000 50000
100000 inserts to /tmp/a.db in 0.671 s = 149057.52 inserts/s
./sqlite_insert 2000000 20000 2000000 inserts to /tmp/a.db in 14.437 s = 138535.38 inserts/s
./sqlite_insert 2000000 50000 2000000 inserts to /tmp/a.db in 15.322 s = 130530.52 inserts/s
Not substantially better. My configuration:
AMD Athlon(tm) 64 Processor 3000+ 1GB RAM 2 x Maxtor 200GB SATA150 7200RPM 8MB HD
I'm running OpenBSD 3.6 with a customer kernel compiled to support
OpenBSD's software raid (RAIDFrame). I have the 2 drives arranged in a
RAID 1 configuration.
As a confirmed OpenBSD devotee these numbers make me very happy. I use it for the security, but I can see that there are good performance reasons as well. I guess we know where the app should run if they need that kind of performance.
Clay Dowling
-- http://www.lazarusid.com/notes/ Lazarus Notes Articles and Commentary on Web Development