Page 1 of 1

View in memory duration

Posted: Tue Oct 14, 2008 4:10 pm
by armas
Hi

I calculated a large view that took 3 minutes to calculate, then close Server Explorer, Excel, etc...then went through the view again one hour later and took a few seconds.

Then I came back a couple of days later and took 3 minutes or more to be calculated.

For how long a view is stored in memory??

thanks

Re: View in memory duration

Posted: Tue Oct 14, 2008 4:18 pm
by John Hobson
Armas

The cached values get discarded if a change occurs in the underlying data - this can be 1 second or 1 week.

I don't think there is any automatic recycling of the cache, although it can be a good idea to do this manually once in a while

Re: View in memory duration

Posted: Thu Oct 16, 2008 8:23 am
by Steve Vincent
Just to clarify that, a "change" includes;
  • Editing of a rule
    Change of data
    Change of elements

Re: View in memory duration

Posted: Mon Oct 20, 2008 9:44 am
by Olivier
Hi all,

John,

What actions are you refering to when you talk about refreshing manually the cache ?

Thanks

Olivier

Re: View in memory duration

Posted: Mon Oct 20, 2008 11:02 am
by John Hobson
I was really talking about restarting the server so that you start off with an empty cache again.

J