On Wed, 3 Feb 2016 23:25:33 +0100 GB <gbinfo at web.de> wrote: > So where have you got this wisdom from? It's just plain Bullshit! > > Just as most cache managers do, Windows cache manager uses some sort of > LRU caching scheme. So all data once read from file is kept in memory > until either some memory pressure occurs or it is simply pushed out by > newer data. Actually, from what I've experienced, I'd recommend to size > sqlite's memory to fit for your largest transactions and leave most of > the caching to the OS. > > And yes, unlike in many *NIX implementations, Windows' > FlushFileBuffers() call DOES issue according write commands to the > hardware, so setting PRAGMA synchronous ON/OFF makes a big difference in > write performance on Windows systems. >
I agree there are too much incorrect statements about Windows's behaviour, however, on a Linux system, I could check (just for testing it) `PRAGMA synchronous ON/OFF` makes a difference with at least small transactions, while it's less perceptible with big transactions (small and big is vague, that's just to keep the wording simple). I guess on Windows too, when the transactions are big, using synchronous mode or not, will make less difference than with small transactions, understandably. -- Yannick Duch?ne
