too many data bounded controls causing ASP.NET performance issues?

Question

1.00/5 (1 vote)

See more:

, +

Hello,

Hope all is well, I am experiencing performance issues on my ASP.NET web application, I think the problem resides with possibly having too many data bounded controls (dropdown lists, grids, etc.) on my web form.

Can this cause performance issues?

I have all of the forms on one ASPX page, which in turn displays relevant content based on selection of tabs, etc.

My questions is are all these SqlDataSources reading data from the database server during page load? I am not sure if this is the case or the problem but it seems like potentially all datasources from all pages are loading data when the page is loaded which in turn is causing the web page to be way too slow.

Also does having too many SqlDataSources cause performance issues? I can find anything on this matter... appreciate your feedback and info...

Many Thanks!
Shirzad Sharif

Posted 24-Oct-15 22:49pm

Shirzad Sharif

Add a Solution

Comments

Krunal Rohit 25-Oct-15 5:12am

I'd suggest you to use jQuery AJAX to load your data.

-KR

Sinisa Hajnal 26-Oct-15 3:36am

If everything loads at the start, put all queries into single stored procedure and get the data in one go. If you react to events, fill the data on the events (tab changed, page load, button click or whatever) that cause particular control(s) to show/load.

Shirzad Sharif 26-Oct-15 6:21am

thanks guys!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shirzad Sharif · Accepted Answer · 2015-10-26T00:15:00

Thanks, what I ended up doing was use the ObjectDataSource instead of SqlDataSource, this seems to be pretty significant as it adds a DLA (Data Access Layer) to the application.

http://www.c-sharpcorner.com/UploadFile/6897bc/using-objectdatasource-control-and-its-advantage-over-sqldat/[^]

Also ended up publishing the website and it seems to run significantly faster than in debug, which made me look into Visual Studio settings to make some changes so the debugger runs faster...

I am still interested in further optimizations to the way data is being accessed, but I will have to do this at a later date.

Thanks,
Shirzad