> What exactly happens when I change the cache_size (both increase and > decrease size)?
A variable is set. > What happens to the data that's there in the result cache at the time > when the instruction PRAGMA cache_size = 0 is executed? Nothing. The aforementioned variable is set to 10 instead of the specified value. > Will there be any memory that will be freed up when I reduce the size of > result cache? No. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------