[MonetDB-users] quer cache
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.
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. Regards, Stefan On Mon, Jan 24, 2011 at 03:14:09AM -0800, Ramkumarlak wrote:
-- | 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) |
Thanks Stefan. Stefan Manegold wrote:
-- View this message in context: http://old.nabble.com/quer-cache-tp30747505p30748055.html Sent from the monetdb-users mailing list archive at Nabble.com.
participants (3)
-
Ramkumarlak -
Stefan Manegold -
Ying Zhang