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!
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.