my developemnt system is a Win XP, with of course NTFS, I don't know which drive it has, I guess a standard 7200 rpm.
I tried also on a Win 2000 and Vista, as expected Vista appears to be the slowest even this machine has the best hardware, theoretically. All measurements vary +- 20%. Just for my curiosity: Is linux considered to be faster than Windows here ? kind regards Marcus D. Richard Hipp wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users