Post reply

Report takes longer time in report manager than solution file

  • March 29, 2011 at 5:40 am

    #237549

    Hi,

    I have a report which when run directly in solution file takes 2mins, but when deployed and run through report manager it takes 10 mins. Not sure whats happening.

    Please suggest.

  • March 29, 2011 at 5:58 am

    #1304784

    What's different between the 2 environements?

  • March 29, 2011 at 7:06 am

    #1304826

    Are you using a stored procedure? If so, you may want to investigate Parameter Sniffing and the solution to parameter sniffing.

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

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