On Fri, Apr 08, 2005 at 11:01:02PM -0400, Al Danial wrote:
[...]
> What kind of insert performance do you see on your machine? If it
> is substantially better than 120 kinserts/s what kind of hardware
> do you have? I'm especially interested in how much faster the
> code runs on systems with multiple disks in a RAID 0 configuration.
> Are there other tricks to speeding insert performance? Is it even
> reasonable to ask for more? -- Al
./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.
enjoy,
-jeremy
--
========================================================================
Jeremy Hinegardner [EMAIL PROTECTED]
