Home Forums Reporting Services Reporting Services 2008 Development SQL Query runs fast, SSRS runs S L O W . . . . RE: SQL Query runs fast, SSRS runs S L O W . . . .

  • October 23, 2013 at 3:16 pm

    #1661106

    Ok Guys,

    I have posted the SQL (See prev post) and the execution plan. I have added the missing indexes, and finally I have added a 'rep' parameter so that the report only returns one rep at a time. Again, the RAW SQL returns in < 1 second. SSRS takes 3 + minutes to return 1 rep, max 30 rows of data.

    I'm completely lost here...

    Any brilliant ideas?

    Lost in Toronto....:w00t: