Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reports Running Faster in IE8 than BIDS Expand / Collapse
Author
Message
Posted Wednesday, July 9, 2014 4:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:36 AM
Points: 89, Visits: 344
Hi,
I am just wondering how this works as it is not really a problem.
When I run a report deployed to the report server via IE8 the reports renders in 3 seconds on average.

When I run this report from within BIDS the report renders in 24 seconds on average.

What is the reason for this happy occurence? Is it the fact that deploying the report creates some kind of execution plan on the report server?

Thanks.


Dave Morris

"Measure twice, saw once"
Post #1590658
Posted Wednesday, July 9, 2014 11:10 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:26 AM
Points: 10,381, Visits: 13,436
When running the report in BIDS all the work (other than the database work) is being done locally on your PC. When running in IE from a report server the report server is doing most of the work and IE is just rendering the HTML.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1590870
Posted Thursday, July 10, 2014 1:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
seatedElephant (7/9/2014)
Hi,
I am just wondering how this works as it is not really a problem.
When I run a report deployed to the report server via IE8 the reports renders in 3 seconds on average.

When I run this report from within BIDS the report renders in 24 seconds on average.

What is the reason for this happy occurence? Is it the fact that deploying the report creates some kind of execution plan on the report server?

Thanks.


This just means you have a very crappy computer




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1591037
Posted Thursday, July 10, 2014 3:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:36 AM
Points: 89, Visits: 344
Thanks for the reply.


Dave Morris

"Measure twice, saw once"
Post #1591061
Posted Thursday, July 10, 2014 3:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:36 AM
Points: 89, Visits: 344
Ha, ha, too true unfortunately

Dave Morris

"Measure twice, saw once"
Post #1591062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse