That will do nothing. I explicitly set the cache mode. I always disable all "Mystical Microsoft Magical Behaviour" wherever I can find it -- though there are a very few "autotuning" things that work properly by themselves, just not many (unless they originated with an actual Engineer rather than a Microsoftian).
I despise magical behaviour since I discovered long ago that it usually does not work properly -- and that holds true to this very day. If I want something then I will set in explicitly and not depend on Microsoft-AutoMagic (prayer mode). Determinism and reduction of complexity is how one obtains reliability. Enabling (or not disabling) "Magic Modes" is (a) non-deterministic and (b) increases complexity, thus reducing reliability and reproducibility. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin >Sent: Friday, 15 June, 2018 17:10 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >On 15 Jun 2018, at 11:21pm, Keith Medcalf <kmedc...@dessus.com> >wrote: > >> And you are correct, it appears to be related to "reading >backwards" somehow. > >If you're comparing the two directions of reading the same file, >there are ways to fake out Windows' read-ahead tricks and see if >they're what's messing up your program. > >A) Plug in a Flash drive and create/open the file on that instead of >the boot drive. > >B) Rename the file to something which doesn't have a database-like >extension. I suggest an extension of ".333'. > >Try those -- separately not together -- and see if you see any >difference. > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users