On Nov 2, 2011, at 11:31 AM, Fabian wrote: > 2011/11/2 Mr. Puneet Kishor <punk.k...@gmail.com> > >> >> Others will have better answers, but methinks that when you reboot the >> computer, the operating system's caches are flushed out, which slows the >> operation. Try working with the db for a bit (SELECT, repeat INSERTs, etc.) >> and notice if the speed increases again to what you expect. >> >> > The reason I reboot the PC for the test, is because I want to have the > caches flushed out, and I fully expect it to make things slower, but not by > the degree (factor 300) i'm experiencing.
ahh, so you *are* getting expected behavior, just not what *you* expected. Did you have a different number in mind instead of a factor of 300? And, if so, why? I am genuinely curious -- I know nothing about Windows. I rarely reboot my computer -- my desktop iMac hasn't been rebooted in several weeks now. I did reboot my MacBook Air a few days ago for a software update, but usually that too goes through a few weeks before it is rebooted... when I do reboot them, I experience everything to be slow for the first 10-15 mins or so. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users