How to make filtered chart faster

[AMBERKIMS]

I am making confluence report pages with lots of filters about Jira status.

For example,

I make a list of items with "custom jira charts"(1) on top

I make a "custom jira charts" using a simple search macro using (1) and added a quick filter for "updated dates" for last 1 week.

I make another "custom jira charts" using a simple search macro using (1) and add a quick filter for status in specific status.

I make another "custom jira charts" using a simple search macro using (1) and added another quick filter.

and so on....

This page makes me use lots of memories, and it takes time to update and display the chart.

Is there any way to make it faster?

[Laurie Sciutti]

hello @AMBERKIMS and welcome to the Community!  Do any of your simple search macro queries overlap?  In other words, can you combine any of the queries and make more quick filters to drill down? I've done this before by making the simple search a bit more general and then creating multiple quick filters (users can select multiple quick filters for one result so this very well). 

If that doesn't work, what about separating into different Confluence pages?

Also, have you tweaked the settings (Performance Options) at all (see below)?  That might help.  

Additionally, for the results widgets, do you limit the #rows returned when the page loads?  I've found this to really impact performance and usually set the row limit to 5 or 10, depending on the query and what else is on the page....

HTH.