Only possible agent is MSE, and process monitor doesn't show it eating IO, likely since it's not a watched extension. I saw the article about the extensions a while ago, so we decided to use .s3db for our database extension.
I tried changing block size to the native block size and it only sped up by ~5%. ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Roger Binns [rog...@rogerbinns.com] Sent: Friday, November 30, 2012 1:14 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 30/11/12 09:41, David de Regt wrote: > Is there something ridiculous about the windows file system performance > that hoses sqlite's open/read/write/close transaction cycle? There are multiple possible confounding factors. One is that you could have tag alongs running - virus scanners, backup agents, content indexers etc. I strongly recommend running Sysinternal's Process Monitor which will show file activity and point fingers. Another is that Windows monitors files with certain extensions as part of system restore. If you happened to pick one of the extensions for your database you'll find it a lot slower: http://msdn.microsoft.com/en-us/library/aa378870.aspx There are some other tradeoffs in the NTFS implementation, such as how all directory information is stored in a single large "file" (MFT). It is also possible that the blocks of the filesystem don't align with the blocks of the SSD which will cause the SSD performance to be a lot slower. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlC5IaoACgkQmOOfHg372QQjRgCdG4HCUkm9K/fRqIESJDfusiKG WGQAni80PNqPHynWWYZxil1QRZmUEdZE =nGIY -----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
