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 recipient, 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