On 11/02/2011 12:31 PM, 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.
In the past I've seen recommendations to open and read the file, perhaps
by making a copy of the file, then try your inserts. If the time does
goes back down, then you know it is file cache issues.
David
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
