Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread Noah Hart
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

Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread D. Richard Hipp
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

Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread Noah Hart
>> 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

Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread Noah Hart
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

Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread D. Richard Hipp
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,

Re: [sqlite] Looking for generic speed test results

2008-08-12 Thread 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. > >