Improving the report performance.

  • Hi,

    I have a report using 4 matrices and 3 stored procedures to populate those matrices.The stored porcs while executing through the sql server management studio dont take much time. But when i execute the report, it takes around 5+ minute to execute.

    Any suggestions why is it happening and how can i improve the report's performance.

    Thanks

  • Hi,

    Just a suggestion. I would recommend you create one stored procedure and get all the data into one table according to your parameter. Just insert one field called type which will differentiate for your 4 matrix. Now get the data into RS from that table and do some filter on table/matrix itself.

    It might help.

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

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