Report performance tips
Does anyone have tips/hints on writing reports or making report updates to optimize performance?
Occasionally I will run a report and it will get stuck in the "Your report is running." prompt and never return results. I've waited about 15 minutes at times and it still didn't return. At the time I check both the DB2 and Insight servers and both seem fine and do not seem overloaded, and when I run the underlying queries via Report Studio that are being run in the report, they return quickly.
Any tips or ideas to speed things up would be helpful - thanks!
Occasionally I will run a report and it will get stuck in the "Your report is running." prompt and never return results. I've waited about 15 minutes at times and it still didn't return. At the time I check both the DB2 and Insight servers and both seem fine and do not seem overloaded, and when I run the underlying queries via Report Studio that are being run in the report, they return quickly.
Any tips or ideas to speed things up would be helpful - thanks!