SQL Server Performance

SSRS Report load through URL Performance problem

Discussion in 'SQL Server 2005 Reporting Services' started by Ismailc, Sep 3, 2009.

  1. Ismailc New Member

    Good day, I need help.
    In VS2005 SSRS when preview the report it runs for 2 seconds and then I deploy.
    But I call the report's URL from a web page on load event.
    The web page without the report opens as normal quickly but with call the SSRS report it takes 20 seconds to open & run.
    Is there something i can do or missing, a property to speed report load or run?
    Please Assist
    Ismailc, Sep 3, 2009
    #2

  2. FrankKalis Moderator

    Have you found a solution or workaround to this issue in the meantime?
    FrankKalis, Sep 10, 2009
    #3

  3. Ismailc New Member

    No, but it's fine.
    Ismailc, Sep 11, 2009
    #4

  4. FrankKalis Moderator

    Thanks for feedback!
    FrankKalis, Sep 11, 2009
    #5

  5. Madhivanan Moderator

    [quote user="Ismailc"]
    No, but it's fine.
    [/quote]
    There is always time difference when the report is viewed in working environment and via exe/web page
    Make sure you applied enough filters to get only data that are needed
    Madhivanan, Sep 11, 2009
    #6

Share This Page