I'm working on a report to improve its performance. One of the pages has three "top-10" lists that each have separate queries. Each query reads the same table so if I were to find a way to combine them into one query, would that improve performance of the page? In other words, if I combine queries A, B, and C into query D, would it run query D one time for all 3 lists or does it still run D once for every list?
Thank you all. :)
Quote from: pechmo on 09 May 2022 07:58:34 AM
I'm working on a report to improve its performance. One of the pages has three "top-10" lists that each have separate queries. Each query reads the same table so if I were to find a way to combine them into one query, would that improve performance of the page? In other words, if I combine queries A, B, and C into query D, would it run query D one time for all 3 lists or does it still run D once for every list?
Thank you all. :)
Hi,
The report will run the query separately for each container (list, crosstab, chart etc), so even if you combine the three queries into one, you won't see any performance difference in this instance.
The benefit of sharing queries between containers is really just in reducing maintenance - if you need to change the query, you do it once rather than multiple times.
Cheers!
MF.
Could this be a candidate for Use local cache?
Maybe you could create the single query with Use local cache = yes, then that is the source for 3 downstream queries.