On Thu, Aug 6, 2015 at 4:54 PM, Wade, William <bill.wade at dnvgl.com> wrote:
> I'm an SQLite novice, so if I'm wrong about this, I hope someone will > correct me. > > The first query will be slower than later queries for the reason Simon > mentioned. Pedantically speaking, "will" is not quite right. That will _normally_ apply, but depends on the whims (and memory pressure) of the OS. When this question/problem has come up before, some people have suggested "coercing" the raw db file into the filesystem cache with something like: cat mydb > /dev/null (or whatever the equivalent is on Windows) which simply causes mydb to be read into the filesystem cache, independently of sqlite (again, subject to the whims of the OS). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
