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 3.0.8 Fedora core 2, kernel 2.6.8-1.521 /proc/cpuinfo: model name : AMD Athlon(tm) 64 Processor 3200+ cpu MHz : 2043.192 cache size : 1024 KB On a Seagate 7200.7 200GB Parallel IDE drive with ext3: $ ./sqlite_insert 100000 50000 100000 inserts to /tmp/a.db in 0.841 s = 118872.29 inserts/s $ ./sqlite_insert 100000 20000 100000 inserts to /tmp/a.db in 0.848 s = 117858.23 inserts/s $ ./sqlite_insert 2000000 50000 2000000 inserts to /tmp/a.db in 18.446 s = 108424.30 inserts/s Same box with RAID 0 configuration with 2 U160 SCSI Seagate 15000 RPM 18GB Cheetahs (2nd generation, purchased in 2001) with ext3: $ ./sqlite_insert 100000 20000 100000 inserts to ./a.db in 1.177 s = 84977.14 inserts/s $ ./sqlite_insert 100000 20000 100000 inserts to ./a.db in 1.146 s = 87230.96 inserts/s $ ./sqlite_insert 2000000 50000 2000000 inserts to ./a.db in 20.287 s = 98584.18 inserts/s -- Dan Nuffer
