Decrease .aspx webpage load time.

Umesh Modi
Umesh Modi used Ask the Experts™
on
Hii,

I have created an .aspx webpage which takes around 10 min to load fully, is there any solution since there are runtime sql queries which might slowers the page load.

What will be best adaptation to optimized it:-
1. Using Stored procedures.
2. Developing using MVC.

Or something different please suggest.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
you can do some testings by "turning off" some of your web page features (like limit number of records being returned, disable the javascript, remove the load of some images, etc) and then determine which of them are the root cause causing the slowness.

you can also open the Web browser's Inspect feature to see which items are most costly for loading time.

SnapShot.png

Author

Commented:
Thank you for the solution.

But it shows only the external files timeline, there are sql query which fetches data at runtime and show result on my pages.

Does using MVC (Module View Controller) will affect the execution time.
Ryan ChongSoftware Team Lead
Commented:
But it shows only the external files timeline, there are sql query which fetches data at runtime and show result on my pages.

you may use SQL Profiler for diagnosis.

SQL Server Profiler
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler

Does using MVC (Module View Controller) will affect the execution time
it's unlikely, unless your scripts were not written in a correct way.

you may also read through this article and see what can be improved from your end.

How to Optimize Page Load Time
https://www.woorank.com/en/edu/seo-guides/page-load-time
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

using stored procedures is a best process and try to
1.use using() statements, which will handle the connection open and closing,
2.try to reduce the no.of content placeholders
3. dont write too much complex sql queries.


I hope you can understand.
Ryan ChongSoftware Team Lead

Commented:
do you need further assistance here?
Ryan ChongSoftware Team Lead

Commented:
as suggested

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial