FWIW, with our test and prod implementations, we find between a 3 and 10x (300-1000%) increase in almost all of our query times on Windows NTFS over OSX and iOS systems, depending on the query type. We've done a bunch of testing and can verify it every time.
I started a thread on this ~7 months ago, and everyone else was able to verify it too with a simple implementation. No explanations were provided outside of "Windows sucks", "Lol n00b", and "try linux". :) And no, system restore isn't backing up our database files... -David -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Keith Medcalf Sent: Friday, June 28, 2013 2:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Large Database Windows vs Linux That would explain why the best thing to be done with System Destroyer (System Restore) is the same as the best way to handle the Hardware Destroyer (Power Management) in Windows. Disable it completely. > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Roger Binns > Sent: Friday, 28 June, 2013 15:07 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Large Database Windows vs Linux > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 28/06/13 13:17, RSmith wrote: > > Best guess is some other system is trying to also look into that > file, > > making the Windows file manager stutter quite possibly the Win7 > > Preview pane, a 3rd party file indexer service, an anti-virus > system or > > some other > > Those are often called tag alongs since they tag along file i/o > activity. > > Also beware that if your database (or any other file) as a particular > extension then Windows' System Restore will keep making backup copies > whenever it changes. Here is the list of monitored extensions: > > > http://msdn.microsoft.com/en- > us/library/windows/desktop/aa378870(v=vs.85).aspx > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.12 (GNU/Linux) > > iEYEARECAAYFAlHN+ugACgkQmOOfHg372QTTqgCeN3hNpHGON/CaoEx95y9605Qz > GMIAnAtmuJzgo3wwLrZdGOIbA2yWwuRP > =5SeP > -----END PGP SIGNATURE----- > _______________________________________________ > 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
