I am using a stored procedure to load a dataset from oracle. The procedure completes and all data is returned < 4 seconds. The report in SSRS, however, takes an extremely long time to process whether or not there is data provided to the report.
2 Parameters (Ref Cursor for rows, Selected Date)
Data is returned to SSRS in the same amount of time as executed locally on the db.
I am confident the procedure is sufficiently optimized and unrelated to the issue.
Simple report, no filtering, no aggregation
TimeStart 2013-10-04 17:55:04.747
TimeEnd 2013-10-04 18:07:27.047
Any idea what could be causing the *excessive* TimeProcessing?
Again, almost no formatting in the report.
0 Rows in the test pull (so... no rows to process).
It is also worth noting that the processor usage on the SSRS server is not elevated during the extended processing wait time.