On Mon, Jan 24, 2011 at 12:46:39PM +0100, Stefan Manegold wrote:
Hi,
MonetDB's SQL interface does have a query plan cache. This query plan cache cannot be disabled (other than by modifying the respective code and recompiling the system).
IMHO, for "normal" users, there should be no reason or need to disable the cache, unless you want the system to perform the very same task of translating the same query redundantly whenever it is run (and hence "pay" for the translation with every invocation of the same query rather than only once with its first invocation).
As an additional note, cached query plans are kept only while the server is running, i.e., they are "survive" server restarts.
I guess that Stefan actually means "they do not survive server restarts". Jennie
Regards, Stefan
On Mon, Jan 24, 2011 at 03:14:09AM -0800, Ramkumarlak wrote:
Hi,
Does monetdb have query cache ? If so, how do we disable it ? I searched in monetdb5.cong but i did not find any option.
Regards Ram -- View this message in context: http://old.nabble.com/quer-cache-tp30747505p30747505.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users