September 25, 2008 at 11:00 pm
I have a report, having 4 matrices. It uses 3 stored procs to populate these matrices. Report has 8 parameters of which 4 are drop down's and multiselect parameters.
The problem is in case i pass 'all' as value from all the multiselect drop downs, it takes too long a time to generate the report. And in case all parameters are taken as simple text boxes and values are passed, it takes less time for report generation.
Any way to tune the report's performance when we use multiselect drop down parameters?
thanks.
September 26, 2008 at 6:27 am
The first thing you need to determine is if the performance issue is the rendering of the report or the retrieving of data.
If it is the rendering of the report there is not a lot you can do. I'd first look at any aggregations that are done on the report and see if I can do them more efficiently in my queries. Then I'd look for ways to reduce round trips so instead of 3 datasets I have 1 or 2. Would sub reports help things render faster instead of 3 matrices? Do I need all the data on 1 report or can I link to other reports? Can I cache the report and run off the cached report for a period of time (Day, 1/2 day)?
If it is the retrieving of the data then you can tune your queries and create indexes that speed up the return of the data.
Hope this gives you some ideas,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply