I have some active reports that are running slowly (20 minutes to an hour). They are about 3-5MB in size, and look through 5 or 6 million records, which are then aggregated in visualization form.
A couple of the reports contain joined queries (two queries joined together to make a third query). I realize this is very broad, but are there any general recommendations to improve report performance? Perhaps any specific query settings to toggle within Cognos?
Thanks!
Any efficiency tips??
I discovered that turning off the auto-group and summarize function results in better performance, however I still need to play around to see how that impacts the data I'm displaying, and when to toggle it on/off.
Update - The particular report I'm interested in improving runs 5 minutes in our Test environment, and an hour in our production environment. We re-booted the production server, and that same report has different behavior... when filtered for 1 year of data it runs in 5 minutes in production, but when filtered for 2 or 3 years it takes 1.5 hours. Why would that be? Any thoughts?