Dropdown in grid taking long to display data

Question

Hi,In my grid, one of my columns has a dropdown rendered and it works, but the amount of data returned to populate the dropdown is causing a very slow response. I want to speed up the time it takes to display records in the dropdownlist. From the controller, I set the Datasource for the dropdown, from the SQL table. There are more than 64000 records and this is causing the dropdown in the grid to take a long time to open and show the data.What would be the best approach to show the data in the grid dropdown to display faster?

Sujith Kumar Rajkumar · Accepted Answer

Hi Eddie, 
 
Sorry for the delay in providing the response. 
 
We validated your requirement from our end and based on that would like to let you know that even if we render the custom control(either Grid or dropdown list) in a dialog(on row command button click) for filtering and selecting a value, the delay will still occur to display data when 64000 records are set as its data source. So for this case you would have to use remote data and virtual scroll features so that only a set of items are retrieved on initial load from the server and the rest of the items can be fetched and loaded on dropdown scroll.  
 
More details on this can be checked in the below documentation links from the Grid and dropdown list controls, 
 
Dropdown list: https://ej2.syncfusion.com/aspnetmvc/documentation/drop-down-list/data-binding/#binding-remote-data 
                            https://ej2.syncfusion.com/aspnetmvc/documentation/drop-down-list/how-to/achieve-virtual-scrolling/ 
 
Grid: https://ej2.syncfusion.com/aspnetmvc/documentation/grid/data-binding/#remote-data 
          https://ej2.syncfusion.com/aspnetmvc/documentation/grid/virtual/ 
 
If this helps achieve your requirement, then you can directly implement this in the Grid’s edit dropdown without facing any delay problems to load the data. So please confirm us if this case is okay for you or if you need to share any further information based on which will provide the sample for achieving this. 
 
Regards, 
Sujith R

Rajapandi Ravi · Answer

Hi Eddie, 

We suggest you use Virtual scrolling concept to load large data in the DropDownList. We have used take method in the DataManager query to limit the items loaded initially. Kindly refer to the following documentation for more information 

https://ej2.syncfusion.com/javascript/documentation/drop-down-list/how-to/achieve-virtual-scrolling/ 

Regards, 
Rajapandi R

Eddie Willcox · Answer

This does not look like it's going to work.

My second idea is to add a custom command to search for what I need. So I will want to add a custom command button in the grid. When this button is clicked, a dialog must open with the data being searched for and once selected on the dialog, the grid must be populated with the selected value from the dialog.

If this is possible, can you please provide a sample?

Balaji Sekar · Answer

Hi Eddie,Query #1: This does not look like it's going to work.Please share the more details about the facing problem to us that will help to validate further.Query #2: Add a custom command to search for what I need. So I will want to add a custom command button in the grid. When this button is clicked, a dialog must open with the data being searched for and once selected on the dialog, the grid must be populated with the selected value from the dialog. Before proceeding the above query we need to conform that you want bind the custom command button and it will rendering every row then it will popup a dialog when we perform click action. Here you want show the respective row details on dialog or list of value(if you have screenshot for this, please share to us) and Grid will populate the row’s data of respective row based on selected value from the dialog.If we misunderstood your requirement, please share the details briefly to us that will help to validate further.Regards,Balaji Sekar.

Eddie Willcox · Answer

Query 2:in the grid, I want to render a custom command button for each row in a specific column. When the button is clicked, a dialog must open to show from a specific data set (will be a SQL query). The dialog must then allow me to select a value from the listed data (i was thinking of using a grid here or a select list with filtering). Once the value is selected, the dialog must close and the value selected from the dialog must be added to the cell where the command button was clicked.I hope that makes sense.

Balaji Sekar · Answer

Hi Eddie, 

Thanks for your update. 

We are working your query with provided the information and we will update further details on or before November 12. 

Until then we appreciate your valuable patience. 

Regards, 
Balaji Sekar.

Eddie Willcox · Answer

Hi.Any further news on this?

Eddie Willcox · Answer

Thanks for this. I will test it out.

Mohammed Farook J · Answer

Hi Eddie,  
 
Thanks for your update. 
 
We will wait to hear from you. 
 
Regards, 
J Mohammed Farook