Actually, you need to pull the power plug after you shut it down for more than 30 seconds, then plug it in and reboot. Only then are you sure the all the cache has been flushed.
Alternatively, run the test many times (say 1000) and average the results. > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of ??? > Sent: Friday, 11 December, 2015 01:29 > To: SQLite mailing list > Subject: Re: [sqlite] ABOUT ROWID > > 1.Reboot computer > 2.Shut down computer ,and then start computer > > the two method above , can also solve the cache perfectly. > the testing computer is dell. > > At 2015-12-11 16:22:44, "Clemens Ladisch" <clemens at ladisch.de> wrote: > >Hick Gunter wrote: >> 2) run each query in a new process (so each one > will need to read the data from disk) > >This does not help against the > file cache of the OS. > > >Regards, >Clemens >-- > >> This communication > (including any attachments) is intended for the use >> of the intended > recipient(s) only and may contain information that is >> confidential, > privileged or legally protected. Any unauthorized use or >> dissemination > of this communication is strictly prohibited. If you >> have received this > communication in error, please immediately notify >> the sender by return > e-mail message and delete all copies of the >> original communication. > Thank you for your cooperation. > >This e-mail contains public information > intended for any subscriber of >this mailing list and for anybody else who > bothers to read it; it will >be copied, disclosed and distributed to the > public. If you think you >are not the intended recipi > ent, please commit suicide immediately. >These terms apply also to any e- > mails quoted in, referenced from, or >answering this e-mail, and supersede > any confidentiality notices in >those e-mails. Additionally, > confidentiality notices in those e-mails >will incur legal processing fees > of $42 per line; you have agreed to >this by reading this confidentiality > notice. >_______________________________________________ >sqlite-users > mailing list >sqlite-users at mailinglists.sqlite.org > >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
