View in memory duration

[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

[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

[Steve Vincent]

Just to clarify that, a "change" includes;

• Editing of a rule
  Change of data
  Change of elements

[Olivier]

Hi all,

John,

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

Thanks

Olivier

[John Hobson]

I was really talking about restarting the server so that you start off with an empty cache again.

J