From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of manohar s Sent: Monday, February 23, 2009 4:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite caching
Thanks for your quick replies, although restarting my machine, disc cache is cleared, I am trying to find an utility which could do the job without requiring a restart. Regards, Manohar.S ==================== Greetings, Manohar, You can do something like close your sqlite application, copy a large unrelated file to the nul device, then restart your app -- that should clear the cache of the sqlite data (if the o.s. uses a "least recently used" cache instead of "least frequently used" cache -- someone more knowledgeable may be able to say for a particular O.S.) However, most any well-performing database is going to depend on a good RAM cache -- either from the operating system or within it's own code -- or both. And it's already been mentioned that what you're seeing is not caching of your RESULTS but instead caching of portions of the database itself. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
