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?
Post a Comment for "Why Do Insertions And Deletes Take Over 100 Times Longer On Windows 7 Than Mac 10.9?"