If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report slow...performance problem

Started by lorenmario, 14 Jul 2011 03:07:05 PM

Previous topic - Next topic

lorenmario

I have a list report in Report Studio, accessing an Oracle database. The problem is that this report has some 100 columns and are accessing 4 large tables. The query is taking 3 hours to perform.
I need to make the report more quickly, how do I improve performance?
Can I use a technique in Report Studio, or need to change the model of the Framework?
Thanks!

Lynn

There are a lot of things that can be looked into for improving performance, but it isn't always a simple answer to provide because there are numerous variables to consider.

I would suggest starting with the DBA to see if you can figure out what is happening on the database side. Have them capture the the SQL as it is submitted. Then take a look to see if you are hitting indexes or not. See how long the database request takes. Then you can have an idea if there is, perhaps, some significant local processing taking place that is the culprit.

You might also search this forum and others to see other similar posts about performance to become familiar with the various methods available.