Re: [sqlite] New benchmark comparisons
- Original Message - From: "Brandon, Nicholas (UK)" <[EMAIL PROTECTED]> Just had a quick look and noticed a peculiarity. SQLite seems to do pretty well across the board except in the graph for "INSERT 1 Row Test (implicit transaction)". It seemly does well except when using the SD card. Then I noticed your labelling is not consistent across all the pictures. Is that a mistake or is it what you had expected? For me it would be easier for my brain to compare if you had them in the same label order >across the pictures (i.e. SQLite (M), SQLMobile (M), SQLite (C) ...) I had originally arranged them by storage medium best to worst, but I agree it was somewhat confusing to have the order changed midway through, so I changed it back. The one thing that really impressed me was Join Test #2, which joined 3 tables and returned a sum on a column in the 3rd table. The *only* database that was able to even get near SQLite was MS Sql Server, which actually beat SQLite soundly -- returning a full 500ms sooner than SQLite did. All the other database engines I tested completely tanked that test. Robert
Re: [sqlite] New benchmark comparisons
- Original Message - From: "Denis Sbragion" <[EMAIL PROTECTED]> Hello Robert, At 06.36 06/02/2006, you wrote: ... Also coming up next week are comparisons vs. Sql Server Mobile, which is where SQLite is really racking up some wins recently. interesting but, be careful! Last time I checked benchmarking was explicitely forbidden by the SQL Server end user license. Probably the same apply to SQL Server Mobile. BTW we're using sqlite under Windows CE since at least 3 years, and we have no intention at all to get back from there. I've yet to find a real situation where sqlite is the bottleneck. This is expecially true for our single user/single thread/no locking typical application. I will never thank enough DRH and the other sqlite developers and contributors for their invaluable work. I had originally blanked out the Sql Mobile scores, but then I found other folks on the net posting benchmarks and even found an MS employee's blog referencing some scores someone posted (and even posting a link). After that I decided what the hell. Robert
RE: [sqlite] New benchmark comparisons
>It did pretty well against Sql Server Mobile as well. I just posted those >benchmarks here: >http://sqlite.phxsoftware.com/forums/623/ShowPost.aspx Just had a quick look and noticed a peculiarity. SQLite seems to do pretty well across the board except in the graph for "INSERT 1 Row Test (implicit transaction)". It seemly does well except when using the SD card. Then I noticed your labelling is not consistent across all the pictures. Is that a mistake or is it what you had expected? For me it would be easier for my brain to compare if you had them in the same label order across the pictures (i.e. SQLite (M), SQLMobile (M), SQLite (C) ...) Regards Nick This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person.
Re: [sqlite] New benchmark comparisons
Hello Robert, At 06.36 06/02/2006, you wrote: ... Also coming up next week are comparisons vs. Sql Server Mobile, which is where SQLite is really racking up some wins recently. interesting but, be careful! Last time I checked benchmarking was explicitely forbidden by the SQL Server end user license. Probably the same apply to SQL Server Mobile. BTW we're using sqlite under Windows CE since at least 3 years, and we have no intention at all to get back from there. I've yet to find a real situation where sqlite is the bottleneck. This is expecially true for our single user/single thread/no locking typical application. I will never thank enough DRH and the other sqlite developers and contributors for their invaluable work. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it
Re: [sqlite] New benchmark comparisons
- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> >Just out of curiosity, another poster here was interested in switching to >mysql. >Did you test mysql? No ... do they have an embedded version I can download, or is it strictly a standalone engine? http://www.mysql.com/products/embedded/ They don't make it easy to find the download link though...=0 Case in point ... I was unable to find any download link on their site! Robert
Re: [sqlite] New benchmark comparisons
> >Just out of curiosity, another poster here was interested in switching to > >mysql. > >Did you test mysql? > > No ... do they have an embedded version I can download, or is it strictly a > standalone engine? http://www.mysql.com/products/embedded/ They don't make it easy to find the download link though...
Re: [sqlite] New benchmark comparisons
- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> Just out of curiosity, another poster here was interested in switching to mysql. Did you test mysql? No ... do they have an embedded version I can download, or is it strictly a standalone engine? Robert
Re: [sqlite] New benchmark comparisons
> >Congrats to DRH! :)=0 > > It did pretty well against Sql Server Mobile as well. I just posted those > benchmarks here: > http://sqlite.phxsoftware.com/forums/623/ShowPost.aspx Just out of curiosity, another poster here was interested in switching to mysql. Did you test mysql?
Re: [sqlite] New benchmark comparisons
- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> On 2/5/06, Robert Simpson <[EMAIL PROTECTED]> wrote: I haven't completed all the tests I want to run, but it makes for an interesting read: http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably add PostgreSQL to the list as well, but as far as I know they don't have an ADO.NET provider -- so I'll have to use OLEDB. Also coming up next week are comparisons vs. Sql Server Mobile, which is where SQLite is really racking up some wins recently. Wow. It did really well. Congrats to DRH! :)=0 It did pretty well against Sql Server Mobile as well. I just posted those benchmarks here: http://sqlite.phxsoftware.com/forums/623/ShowPost.aspx
Re: [sqlite] New benchmark comparisons
On 2/5/06, Robert Simpson <[EMAIL PROTECTED]> wrote: > I haven't completed all the tests I want to run, but it makes for an > interesting read: > > http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx > > I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably > add PostgreSQL to the list as well, but as far as I know they don't have an > ADO.NET provider -- so I'll have to use OLEDB. > > Also coming up next week are comparisons vs. Sql Server Mobile, which is > where SQLite is really racking up some wins recently. Wow. It did really well. Congrats to DRH! :)
Re: [sqlite] New benchmark comparisons
On 2/6/06, Robert Simpson <[EMAIL PROTECTED]> wrote: > I haven't completed all the tests I want to run, but it makes for an > interesting read: Indeed. LOL > I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably > add PostgreSQL to the list as well, but as far as I know they don't have an > ADO.NET provider -- so I'll have to use OLEDB. PostgreSQL 8.1 by default installs with Npgsql, which is .NET 1.x provider. BTW I was also running some benchmarks this weekend. I used drh's speedtest.tcl, but I want to add some more complex queries. Hopefully I'll be able to do that tomorrow. -- Nemanja Corlija <[EMAIL PROTECTED]>
[sqlite] New benchmark comparisons
I haven't completed all the tests I want to run, but it makes for an interesting read: http://sqlite.phxsoftware.com/forums/622/ShowPost.aspx I compared SQLite to Jet (Access), VistaDB and Firebird. I will probably add PostgreSQL to the list as well, but as far as I know they don't have an ADO.NET provider -- so I'll have to use OLEDB. Also coming up next week are comparisons vs. Sql Server Mobile, which is where SQLite is really racking up some wins recently. Robert