With some reports that I have written for SSRS 2008 R2, the performance is problematically slow when the number of rows in the table control gets over a few hundred.
I am curious as to whether this is a problem with SSRS, or something to do with my setup. What sort of performance do any of you forum readers get? Here is a test report that I have been using.
- Create a blank report.
- Create a dataset that executes this query (it simply returns 1000 rows of dummy data)
declare @d table (id int, Result varchar(50))
declare @i int
set @i = 1000
while @i > 0
insert @d values (@i, 'Data')
set @i = @i - 1
select Id, Result from @d
- Add a Table control
- Add the ID and Result fields to the table detail fields
- Set the "Keep together on one page if possible" option in Tablix Properties / General / Page break options
- Deploy the report to the report server
Now, when you view the report with Internet Explorer, how long does it take to render and display the report? For me, it takes 20 to 30 seconds, which is terribly slow for 1000 rows.
When you view the report with Google Chrome, how long does it take? For me, it takes about 2 seconds, which is an enormous increase over IE.