my app uses firedac (delphi xe7) access sqlite.
the mac version 12 times slower windows version.
i have journal_mode turned off, , no journal files appear.
the difference can see mac has checkpoint_fullfsync turned on default (it's turned off default in windows). i've turned off on mac 12x slowdown persists.
the mac latest yosemite. sqlite3 -version reports 3.8.5.
windows 7 using whatever version of sqlite3 baked firedac.
what cause such huge difference in performance?
as da-soft said in comment, setting fdconnection.resourceoptions.silentmode true solves issue. queries ten times faster on osx.
Comments
Post a Comment