In all cases, copying a large file in a ramdisk (on linux: /dev/shm) would clear all cache (ie no space for it)... just make sure you dont fill the ram (have some swap space, cache is only held in ram).
Simon On Mon, Feb 23, 2009 at 1:29 PM, Griggs, Donald <donald.gri...@allscripts.com> wrote: > 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 > -- When Earth was the only inhabited planet in the Galaxy, it was a primitive place, militarily speaking. The only weapon they had ever invented worth mentioning was a crude and inefficient nuclear-reaction bomb for which they had not even developed the logical defense. - Asimov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
