Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi,
 
I have a combobox in my page . More than 20 thousand records will be selected and loaded into this combobox. While clicking this combobbox it's very slow to display the contents and takes more time to respond. How can i avoid this situation.
 
Thanks,
Velkumar.
Posted 16-Aug-12 0:53am
Comments
Timberbird at 16-Aug-12 7:12am
   
You mean you first force client's browser to download 20k records and then make user select one item from that huge list? Simply don't do that. You can split the list into different categories and first let user pick a category, or use any other workaround, but keeping that long list is just unacceptable
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

1) Limit the number of elements shown in the combo box, otherwise it would defeat the usability of the control if the user has to browse through all that data to get to the item they want. For limiting data, you can try loading 5 items or 10 items at a time and when the user scrolls past the last one, you load the next set. Not sure how to do it, but definitely worth exploring.
 
2) Consider redesigning your app so instead of using a combo box perhaps use a GridView with paging.
 
3) Using UpdatePanel intelligently would make sure that this massive data doesn't always get reposted and hence doesn't bloat the view-state and therefore reduces the page size and the amount of HTML to render and hence becomes faster.
 
hope this helps.
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Why do you want to display 20000 records in Combobox?? Do you think user will be scrolling down and check 20000 records to select one record?
 
Try something else like autocomplete textbox or gridview with paging.
 
its very bad idea to load 20k records in a combobox.. Even if we make some changes still the performance will be an issue here always
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hi,
 
You can add your custom control in your page. That custom control should have features like,
 
1) Paging for 10/20 records a page.
2) page should be navigate through Next/Previous/First/Last/Goto.
3) You need Searching in your custom Combobox.
 
Here[^] some basic idea about Custom control.
 
Hope this helps you
 
Thanks
-Amit Gajjar
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

hi,
 
tell me one thing why should u bind these much amount of data in combo box?
 
thanks.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 5

hii,
instead of binding with combobox use autocomplete extender with textbox which will help user with limited amount of data
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 458
1 Maciej Los 375
2 OriginalGriff 338
3 CHill60 205
4 Yogesh Kumar Tyagi 160
0 OriginalGriff 6,152
1 Sergey Alexandrovich Kryukov 5,312
2 Maciej Los 3,279
3 Peter Leow 3,184
4 DamithSL 2,490


Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 16 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100