Specific screen is very slow

Hi there,

We have  a website in which a particular page is very slow when moved to the main server. All the other pages work well which make similar database calls, so there is some some problem related to a specific screen only. Also if we run this page on our local environment then it runs fine.

The website runs on IIS 7.0 and uses ASP.Net 4.0 (c#). The database is MSSQL 2008 R2.

This screen has quite a bit of processing and various types of controls like panel, Div, grid and user controls are used to render the page.

Please see the embedded file for the website credentials as well as other details to have a look at the slow processing.

I need this fixed urgently as the website is already live and only this functionality (which is the major) one is causing issues to the customer.

Thanks in advance for your help.Website-screenshots.docx
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I think it will be better if you create your web application using MVC4 it is very fast and effective.
Couple of things you might want to check:
1: How much time your DB query is taking. Add some time stamp on start and end of your  db call to see how long it's taking. Something like this. You can use SqlProfiler or ActivityMonitor in SqlManagement Studio for checking the performance.

2: Use FireBug in FireFox or Developer Tools in IE to see the network traffic and time taken on each request.

3: See if you can compress your response.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TUS11Author Commented:
We have tried compressing as well as disabled viewstate which has considerably improved the performance.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.