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 <[email protected] >> > wrote: >>>> On Tue, May 26, 2009 at 9:47 PM, Marcus Grimm <[email protected] >>>> > >>>> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
