Data Entry Web Application Running Slow

Posted on 2009-04-30
Medium Priority
Last Modified: 2012-05-06
I have a web application that is used primarly as a data entry application.  There is a delay when loading the form and saving a form.  The dropdown boxes all run from sqldatasoure controls along with a sqldatasource control that runs for the entire form that keeps track of the current record.  I am trying to figure out the best way to speed up the database calls.  Is the best thing to do caching?  Would using web services help at all?  I am using the new Q1 2009 Telerik controls and that has made a difference but any ideas to make the page load faster would be very helpful.  
Question by:NetRuiz
LVL 37

Assisted Solution

momi_sabag earned 400 total points
ID: 24276764
assuming your database quries are not consuming time (since getting data for the drop down lists should not return that many rows) i would suggest you try to chage the way your page load.
let the page load and once it is loaded, use ajax in order to access the database and populate the list controls
try to do it in parallel and it will save you time

Accepted Solution

NetRuiz earned 0 total points
ID: 24282304
How would I do this?  Doesn't the select for sqldatasources run onder the prerender of the control it is attached to anyway so that would be after the page load anyway.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Considering cloud tradeoffs and determining the right mix for your organization.
It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question