How to make active report more efficient in Cognos 11.1?

[pacificbeavs]

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!

[pacificbeavs]

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.

[pacificbeavs]

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?