Check the third party processes running on the respective machines. Virus scanners, file indexing utilities, TortoiseSVN, etc. have been shown to adversely affect performance on Windows machines by locking the journal file at inopportune times.
-Shane On Wed, Nov 5, 2008 at 6:36 AM, Darko Filipovic <[EMAIL PROTECTED]> wrote: > I found that win function FlushFileBuffers (used by SQLite) slows down > performances, > but still don't have explanation why this funcion on some machines works > 10x slower then on others. > > I have used win xp sp2 on all machines where I have tested the behaviour. > > > > > ________________________________ > From: Sherief N. Farouk <[EMAIL PROTECTED]> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Tuesday, November 4, 2008 5:53:16 PM > Subject: Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow > machine > > > The problem is that I'm getting better performance on AMD machine with > > ATA disk, > > but 10 times slower on DualCore machine with SATA disk (both disks are > > at 7200 rpm)... > > I don't understand the source of this behaviour... > > OS? Tried VSTS profiler, VTune or the free CodeAnalyst to look at where the > time is being spent? > > - Sherief > > _______________________________________________ > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
