On May 27, 2009, at 7:51 AM, Marcus Grimm wrote: > > > Nuno Lucas wrote: >> On Wed, May 27, 2009 at 5:58 AM, Marcus Grimm <mgr...@medcom-online.de >> > wrote: >>>> On Tue, May 26, 2009 at 9:47 PM, Marcus Grimm <mgr...@medcom-online.de >>>> > >>>> http://www.sqlite.org/faq.html#q19 >>> the faq as well as the speed comparison speaks about a few dozen >>> of transaction per second... that's why I'm wondering why I'm >>> almost ten times slower on windows... >> >> You don't say much about your hardware or how you are timing the >> transaction speed, so 10 times slower for those numbers are within >> the >> error margin. > > my hardware is just a standard desktop computer, not the fastest... > Okay, if my measurements are within the typical speed range, then this > is the explanation why I see so much slower speed.
Your OS and filesystem configuration have a big impact too. I've notice, for example, that transactions are really slow on RieserFS on linux compared to Ext3. What OS are you using? And what filesystem? D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
