Post reply

Reporting Services: great difference in report execution time versus the query execution time ?

  • October 11, 2007 at 6:57 am

    #178839

    Hello ,

    Is there an option/setting/??? that i can change in order to get the report execution time more or less equal on the query execution time ?

    I'm using sql server 2005 and Microsoft SQL Server Reporting Services Designers Version 9.00.2047.00

    I'm having now great differences fe query exec.time 1min , report exec. time 3min.

    Any help would be grate.

    tx

    regards

    Stanja

  • October 11, 2007 at 7:18 am

    #741193

    That depends. Are you doing a lot of grouping or aggregating in the report? Do as much as possible in the code as the report server isn't nearly as efficient as the DB.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

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

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