Skip to Content
0
Apr 21, 2010 at 08:45 PM

Populating Query Cache

41 Views

In MII 11.5 I am using a chart applet and it is being populated by a query that takes a long time to run. For this reason, I am using query caching and I currently have it set to 1 day. In general it works great. The only problem is that I expect the query to be cached after the first time it is run from the chart applet and this does not seem to be the case. I have to load the chart twice before the cache kicks in and then on the third time it is fast as expected. The second time is just as slow as the first.

If I run the same query directly from the query template editor then it seems to be fast on the second time. Any ideas why it needs to be done twice from the chart applet before it is cached?

Thanks,

Mike