Re: [sqlite] Looking for generic speed test results
Will do. Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Tuesday, August 12, 2008 11:55 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Looking for generic speed test results Importance: High On Aug 12, 2008, at 2:46 PM, Noah Hart wrote: >> >> If you want to do a meaningful speed comparison, then speed1.test >> should probably be modified to set PRAGMA synchronous=OFF. > > Would this be true for all the speed tests? I'll open a ticket to > make > that request. The speed1.test script was actually designed to measure changes in performance from one release to the next on my linux workstation. It was not designed to measure the relative performance of different machines. If you want to measure the relative performance of SQLite on different machines, please at least audit the speed1.test script first to see if it is appropriate for the job. D. Richard Hipp [EMAIL PROTECTED] 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
Re: [sqlite] Looking for generic speed test results
On Aug 12, 2008, at 2:46 PM, Noah Hart wrote: >> >> If you want to do a meaningful speed comparison, then speed1.test >> should probably be modified to set PRAGMA synchronous=OFF. > > Would this be true for all the speed tests? I'll open a ticket to > make > that request. The speed1.test script was actually designed to measure changes in performance from one release to the next on my linux workstation. It was not designed to measure the relative performance of different machines. If you want to measure the relative performance of SQLite on different machines, please at least audit the speed1.test script first to see if it is appropriate for the job. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Looking for generic speed test results
>> Such as >> >> SQLite 3.6.1 running under "Vista 32 bit, 2.4GHz, 3G ram, 5000rpmDisk" >> >> speed1-insert1...326279489 uS 10.8195909732183 row/s > >Right off the bat, I notice that I'm getting 101871.8 rows/s under >Linux. Almost 10,000 times faster. These were just dummy numbers I pasted here for the email. >If you want to do a meaningful speed comparison, then speed1.test >should probably be modified to set PRAGMA synchronous=OFF. Would this be true for all the speed tests? I'll open a ticket to make that request. 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
Re: [sqlite] Looking for generic speed test results
Thanks Peter, I think that to start with, I am only interested in "generic" amalgamation compilations. These would run the standard TCL test scripts speed1, speed2, speed3, speed4. That would be a good place to start. Noah -Original Message- From: On Behalf Of Peter Holmes 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. 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
Re: [sqlite] Looking for generic speed test results
On Aug 12, 2008, at 2:15 PM, 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 Right off the bat, I notice that I'm getting 101871.8 rows/s under Linux. Almost 10,000 times faster. The difference here is that the "testfixture" program that runs this test is compiled with -DSQLITE_NO_SYNC=1 which disables the fsync() system call on unix, but does not disable the equivalent FlushBuffers() system call on win32. The -DSQLITE_NO_SYNC=1 compile- time option is the equivalent of hard-coding "PRAGMA synchronous=OFF". That's great for testing, but might not be such a good idea for production programs that need to survive power failures. If you want to do a meaningful speed comparison, then speed1.test should probably be modified to set PRAGMA synchronous=OFF. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Looking for generic speed test results
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 >CPU1GHz2Ghz3Ghz > Delete8 9 10 > Insert10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows Vista 32bit >CPU1GHz2Ghz3Ghz > Delete8 9 10 > Insert10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows Vista 64bit >CPU1GHz2Ghz3Ghz > Delete8 9 10 > Insert10k 20k 25k > Join > Sub-selects > Triggers > Views > > Windows XP 32bit >CPU1GHz2Ghz3Ghz > Delete8 9 10 > Insert10k 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