Skip to Content
0
Former Member
May 05, 2010 at 02:11 PM

Multiple charts with single data provider cache issue

13 Views

Hi - I have a web template with 4 charts on it - a dashboard. All 4 charts are assigned to the same query but each chart is simply displaying a different series of the query result in a separate chart. Is there any way to get the web application to only execute the query once and then populate the other 3 charts from the cache? Currently it is executing the same query 4 times serially and taking a lot longer to display the initial results. Cache mode on query is set to 1 - Main memory w/o swapping. Thanks.