Cache timing

Hi there, I have a question about cache timing.

If I have a complicated derived table that takes ~20 minutes to run, and I want my cache to be good up to the latest hour, should I have the cache bust and refresh 20 minutes before the hour, on the hour, or after the hour? 

Basically, I’d like to know how to time a cache clear and refresh to make sure the new cache is good on the hour, for a full hour.  Hopefully my wording makes sense.

0 0 56
0 REPLIES 0
Top Labels in this Space
Top Solution Authors