title: Windows Pre-Caching SQLite problem
body: <p>SQLite is a great little database, but I am having an issue with it on Windows. It can take up to 50 seconds to perform a query on a 100MB database the first time the application is launched. Subsequent loads take 10% of that time.</p>
  
  <p>After some discussions on the SQLite mailing list, I am told
  "The bug is in Windows.  It aggressively pre-caches big database files<br>
  -- reads in big chunks of the files -- to make it look as if programs<br>
  like Outlook are better than they really are.  Unfortunately although<br>
  this speeds up some programs it makes others act jerky because they<br>
  have no control over how much is read when they ask for just a few<br>
  bytes of file."</p>
  
  <p>This problem is compounded because there is no way to get progress information while all this is happening from SQLite, so my users think something is broken. (I could display a dummy progress report, but that is really cheesy for a sharp tool.)</p>
  
  <p>I believe there is a way to turn the pre-caching off globally, but is there some way around this programmatically? </p>