hi,
I have an application having more than 20 dropdowns and i m populating database fields to dropdownlist...the matter is when i want to enter the page having these dropdowns..it is taking so much time for page to start...
can any one suggest me how to make page to display very fast eventhough having many dropdowns with database fields
what m i thinking is to use javascript to populate database fields..so that performance may increase..what do you people think..
if my thinking seems to be right..can anyone tell me the code to use dropdown with javascript...
Loading
Javeed M ShaikhPosted Nov 16, 2011, 10:00 AM
Any operation that gets a large amount of data from the DB will take a while even though you do it from javascript.
Following are a few options:
1. Populate only necessary dropdowns to start with and than trigger other dropdowns with any (button)event on the page.
2. take a one time hit by dumping the result into the ASP.Net Cache and check if that's null before querying the database again and fill your dropdown from the cache.
3. Keep your page responsive and try to load data Async with Ajax.
rakesh aythaPosted Nov 22, 2011, 11:20 PM