Extremely slow rendering in Internet Explorer 8

Question

Post reply

Extremely slow rendering in Internet Explorer 8

EITCL

SSCrazy

Points: 2301
More actions
November 17, 2010 at 9:33 am

#388249

I have a report Table control which is based on a simple query that returns 1000 rows of data. When I preview the report in BIDS the report executes and displays in 2 or 3 seconds.
But when I publish this report to the report server and execute the report from the server, it is incredibly slow, taking around 90 seconds to render!!
If I use Google Chrome to execute the same report, it takes only 2 seconds.
Why is Internet Explorer taking so long to render the report?
I have checked that it is not the query that is slow - when I monitor the SQL Server, the query itself completes in about 1 second.

Viewing 9 posts - 1 through 8 (of 8 total)

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

Jason S UK Valued Member Points: 54 More actions · Answer 1

Hi. Is the table set to 'Keep together on one page if possible'?

EITCL SSCrazy Points: 2301 More actions · Answer 2

Hi,

Yes, 'Keep together on one page if possible' is selected, so all the 1000 rows appear on one page.

The issue is that the same report takes 90 seconds when viewed with Internet Explorer, but only 2 seconds when viewed with Google Chrome.

Has anyone else experienced this slow performance with IE? If so, have you managed to resove it?

Lowell SSC Guru Points: 323518 More actions · Answer 3

this may be related: when testing an automation tool, someone encountered IE8 being very slow.

there seems to be a Client setting in IE8 that you change to speed it up:

IE8 - Document Mode Set to 'IE7 Standards' - Execution Time is: 00.468

Seconds

IE8 - Document Mode Set to 'IE8 Standards' - Execution Time is: 22.004

Seconds

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

EITCL SSCrazy Points: 2301 More actions · Answer 4

Very interesting! Do you know where in Internet Explorer's settings I can set this? I can't seem to find it.

Lowell SSC Guru Points: 323518 More actions · Answer 5

i don't have IE8 at work, but this website has a ton of screenshots that might help;

:

http://blogs.msdn.com/b/ie/archive/2008/08/27/introducing-compatibility-view.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

EITCL SSCrazy Points: 2301 More actions · Answer 6

Thanks for the link, it was very useful.

I used the Developer Tool (by pressing F12 from Internet Explorer) to do a profile trace of my report in all the eight various combination of modes:

Browser Mode: IE7 Document Mode: Quirks

Browser Mode: IE7 Document Mode: IE 7 Standards

Browser Mode: IE8 Document Mode: Quirks

Browser Mode: IE8 Document Mode: IE 7 Standards

Browser Mode: IE8 Document Mode: IE 8 Standards

Browser Mode: IE8 Compatibility View Document Mode: Quirks

Browser Mode: IE8 Compatibility View Document Mode: IE 7 Standards

Browser Mode: IE8 Compatibility View Document Mode: IE 8 Standards

In all eight configurations, the report still took tens of seconds to render (compared with 2 seconds in Google Chrome!!)

Can anyone else suggest what might be causing this crippling performance?

Lowell SSC Guru Points: 323518 More actions · Answer 7

wow, that was my best guess, As I'm on a listserv for Watin(Web Application Testing in .NET...IE/firefox browser automation)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

EITCL SSCrazy Points: 2301 More actions · Answer 8

Lowell, from your last post I think you have assumed that the problem is fixed. This is not the case - nothing I have tried so far has made the SSRS reports render any faster in Internet Explorer.

I have created another topic (http://www.sqlservercentral.com/Forums/Topic1025852-150-1.aspx) where I've given details of my report, and have asked forum readers to try it and post their SSRS performance results. Hopefully that'll help get to the bottom of the issue.