Hello, Running on Windows 7 - I am noticing that tables in :memory: DBs are read (SELECTED) at a constant rate. However - conventional DBs on disk - even on SSD - are read fast the first time, and much slower subsequently. Closing and reopening a DB for every SQL statement seems to cure this - but obviously is not a solution when you want to run a multi-step SQL script on a database.
Is this a Windows "feature" - caching or otherwise? Is it Sqlite? Looking at perfmon - the initial read "chunk" is > 100K while subsequently it's 4K (the page size). Is there some prefetching taking place the first time around? How do you make it permanent? How do you make Sqlite consistently table-scan from disk? Thanks ! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
