Performance tuning of the matrix report

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

  • 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,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply