Why Do Insertions And Deletes Take Over 100 Times Longer On Windows 7 Than Mac 10.9?

I wrote a script to benchmark insertions and deletes. import os, time abspath = os.path.abspath(os.path.dirname(__file__)) dbname = 'test.sqlite' # dbname = ':memory:' databaseF

Solution 1:

Apparently SQLite performace on Mac vs Win has been a recurring issue. See this discussionfrom 2012.

One key feature seems to be sync parameters.

from the discussion:

On Windows Sqlite by default uses the real/full fsyncs to the hardware as provided by the OS, while on at least OS/X, by default it doesn't. See http://sqlite.org/pragma.html#pragma_fullfsync

Can you try running with pragma sync = off?