I'd be glad to post results for Ubuntu 7.10 on a Dell Inspiron 530 (Dual Core 1.6Ghz) if you're interested. Just supply source code, compile options you want me to use, etc.
Noah Hart wrote: > I understand that memory, disk and processor all play a part in the > speed test results. > > However, I am looking for some benchmarks that would give ballpark > figures for the results. > > Are people willing to post their speed test results, along with OS, CPU > speed and Memory characteristics?" > > Such as > > SQLite 3.6.1 running under "Vista 32 bit, 2.4GHz, 3G ram, 5000rpmDisk" > > speed1-insert1... 326279489 uS 10.8195909732183 row/s > .. > speed2-insert1... 326279489 uS 10.8195909732183 row/s > ... > speed3-1.incrvacuum... 326279489 uS 10.8195909732183 row/s > ... > speed4-join1... 326279489 uS 10.8195909732183 row/s > > etc > > > My goal is to create tables, similar to the following: > > Numbers in Rows per second > > (Assuming > 1GB Ram, and reasonable disk) > > Unix 32bit > CPU 1GHz 2Ghz 3Ghz > Delete 8 9 10 > Insert 10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows Vista 32bit > CPU 1GHz 2Ghz 3Ghz > Delete 8 9 10 > Insert 10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows Vista 64bit > CPU 1GHz 2Ghz 3Ghz > Delete 8 9 10 > Insert 10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows XP 32bit > CPU 1GHz 2Ghz 3Ghz > Delete 8 9 10 > Insert 10k 20k 25k > Join > Sub-selects > Triggers > Views > > > > Regards, Noah > > > > > CONFIDENTIALITY NOTICE: > This message may contain confidential and/or privileged information. If you > are not the addressee or authorized to receive this for the addressee, you > must not use, copy, disclose, or take any action based on this message or any > information herein. If you have received this message in error, please advise > the sender immediately by reply e-mail and delete this message. Thank you for > your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users