Grid w/custom paging and combobox filtering

[Robert]

Hey guys,

We are working with the Grid and struggling to get it to do what we need. Our requirements are as follows:

1. The underlying table will have millions of records, so custom paging of data is critical.

2. Several columns will require multi-select capability. For example, their is a manufacturer column. We need to be able to show all unique values in a combobox, allowing the user to select which ones to filter on. They would check one or more entries and only records with those values would be shown.

3. Date columns require various filter conditions, including "Between" which would show To and From fields in the filter row/header.

Can this be done? We do not want to use RadFilter, and performance is critical. 

Thanks for the help, guys.

 Rob

[Eyup]

Hello Robert,

Thank you for contacting us.

RadGrid's performance basically depends on the rows and columns count. I am not quite familiar with your specific case, however, with a grid of this size implemented with more complex controls, it is possible performance issues to occur. Therefore, as you have pointed out, we suggest you to use one of the following optimizations which enable the grid to generate only the current page, thus maximizing its rendering and performance speed:
RadGrid Custom Paging
Virtual Scrolling and Paging

I believe it will be very helpful if you look through the following articles which demonstrate how to improve your grid's performance and responsiveness:
Grid performance optimizations
Performance Optimization Controls
Telerik Support ( Performance Section )

As for the RadComboBox requirement, please refer to this demo:
Grid Filtered by Combo

You can apply a custom design and functionality to your filtering item according to your needs. Please check out the following demo where the desired date range filtering is demonstrated:
Grid / Filter Templates

I hope this helps. Let me know if you need further assistance.

Greetings,
Eyup
the Telerik team