Database extension is ".dblite" I'm using Process Explorer (http://technet.microsoft.com/en-us/sysinternals/bb896653) to monitor processes cpu and i/o usage.
During these long running queries I am not using any other program. I've terminated any unused service (MS SQL, for example). System idle CPU is at 98-99% during all the time. I've just tried another system (of my colleague) that has Windows 7. Same result: first run took 40 seconds, second: 1 second. 22 июля 2011, 15:28 от Simon Slavin <slav...@bigfraud.org>: > > On 22 Jul 2011, at 12:15pm, Max Vlasov wrote: > > > Do you have and anitvirus software installed? It may scan the file at > > the first usage. > > What is the extension to the filename of the database file ? Windows does > fancy caching for files that have some particular extensions including, IIRC, > '.db'. Unfortunately although this works well for database files used for > Windows it's terrible for ones which aren't. > > If you've used a common extension for the database file rename it '.sqlite' > or something that isn't going to be confused for another database format. > > And to answer your question, no, it's not normal or a known bug. > > Does Windows XP have some sort of task display where you can see what task is > hogging most of the CPU or disk access ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
