September 14, 2013 at 3:38 pm
In an SSRS 2008 rreport that I am working on, I am having a performance problem. The report is taking about 30 minutes to run which is too long. My problem is there is a full file scan.
To make the report run faster, I am thinking I could run queries based upon the selection values of 3 different paramters users can select from. If this is possible can you show me sql on how to accomplish this goal? Would I use the same dataset?
If not, can you show me how you would use multiple datasets?
If my idea does not work, what would you recommend? Can you show me the sql?
September 15, 2013 at 12:33 pm
Hard to say given the limited information. One thing would be to filter as much out of the dataset as early as possible (in the stored procedure, if possible). The other option is to run the report on a schedule (refresh every hour?) and then users can see that. depends how up to date you need the report to be.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply