Isn't it more likely that your database is pulled up into the OS disk cache? Try rebooting the computer between runs and the cache should be cleared.
On Mon, Feb 23, 2009 at 8:44 AM, manohar s <manohar...@gmail.com> wrote: > Hi, > I am doing some performance analysis on my SQLite queries. The problem is > SQLite seems to be caching query results. > I tried restarting my program, that is not helping. only if i don't access > that database for 2 days then it is giving proper profile data. > * > Question* > 1) How can I disable query result caching in SQLite? > > Regards, > Manohar.S > _______________________________________________ > 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
