Does anybody know why does it take less than 5 seconds to pull, for example, 15,000 rows of data in the query but it would take at least 30 seconds to render and generate a report with the 15,000 rows of data? Well, it will be especially slower when graphs and charts are involved.
We tried to cache it to run daily at a specific time, which resolves the issue but clients are not able to view the 'latest' report at current time.
So, is there a way to tweak or configure so the rendering process is quicker?
Looking forward to your opinions. Thanks!