The increase/decrease in memory is almost certainly the cache (after running the command once and before flushing look and see what Task Manager says for "Cached", then look again after you do the flush and see if it releases it. This is memory that would otherwise be unused being used by the filesystem cache. However, since USER+SYS is not equal or close to REAL, that means that there is something else going on that is consuming time (waiting, defender, or that something is being dispatched as a DPC and its execution time is not being attributed to your process).
--- 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 x >Sent: Friday, 15 June, 2018 02:23 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >>Actually I cannot reproduce even if I turn off forced RANDOM mode >for the cache, reduce the size of the >sqlite3 cache to the default, >and make sure the temp_store is on disk (not my default). > >Are you rebooting or flushing the cache between the commands? I don’t >have any problems (except maybe on the first call) if I don’t flush. > >>I do note, however, that the actual CPU used is relatively constant >(USER+SYS) and that it is the REAL time >only that is going "bonkers" >which suggests some process other than sqlite is what is causing the >>slowdown. It could be something the hardware is doing -- I have >never used a "tablet" as if it were a >computer ... > >After rebooting it doesn’t matter how long I wait before running the >test. If it’s some background task it must surely be triggered by >what I’m doing. That said, if the slowness and increasing / >decreasing memory is down to windows caching the data why is ‘sys’ >not able to include it? >_______________________________________________ >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
