Rad Combo Box bind with 50,000 records

[Alexis]

Hi Team,
 We are using Rad Combo boxes in my screen, I need to bind 50,000 records into a a combo box2 depending on the value selected in a combo box1. while binding Page is getting hanged. We are using Stored Procedure to bind the values into combo box2. Please give any suggestion on this ASAP.





Thanks
Alexis A

[Princy]

Hello Alexis,

 

The best approach to optimize the performance speed of Telerik RadComboBox when using huge amount of items is using the load-on-demand feature.  The load-on-demand mechanism loads the items only when the user types or clicks in the field or the drop-arrow image. It filters the Items server-side before they are loaded in the control and the Filter feature performs filtering at client-side. And I recommend you to retrieve data in portions - with use of ShowMoreResultsBox and VirtualScrolling options.

Take a look at the this demo which demonstrates the various Load On Demand Modes.

Thanks,
Princy.

[Cat Cheshire]

In general it is not recommended to load such enormous amount of items in combobox.
No matter whether you use Load On Demand or not - it is obvious that with 50 000 items you will face a performance issue.