Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
tim
- Thread starter neil2grow
- Start date
Neil,
The time a report takes to run depends on many variables, including whether it resolves to a single SQL query, or to multiple queries that Impromtpu 'stitches' together, whether it uses local functions, whether it filters on indexed columns in the database, and whether all of the filter conditions are passed to the database. If you have the ability to manipulate the back-end data, you may be able to speedup your reports by creating additional indexes, views, or summary aggregation tables that off-load some of the work from Impromptu. Even without these capabilties, you can usually tune the report to significantly improve performance by making the best use of what the application and the database provide you.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
Want good answers? Read FAQ401-2487 first!
The time a report takes to run depends on many variables, including whether it resolves to a single SQL query, or to multiple queries that Impromtpu 'stitches' together, whether it uses local functions, whether it filters on indexed columns in the database, and whether all of the filter conditions are passed to the database. If you have the ability to manipulate the back-end data, you may be able to speedup your reports by creating additional indexes, views, or summary aggregation tables that off-load some of the work from Impromptu. Even without these capabilties, you can usually tune the report to significantly improve performance by making the best use of what the application and the database provide you.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!
- Status
Similar threads
- Locked
- Question