I am working with a dataset of about 300,000 items and my DataGrid is slow to respond when clicking around in the filters. If I'm opening a calendar (datetime), dropdown, or especially typing into a textbox for the filter it seems to react slowly after every click or key press.
Let's talk first about the strings and the textbox filter that appears in the header. I added a FilterDelay value to the grid. My thought was that this would let me type in a whole word to be used as a filter before it would go back to my web service & database. However, it still seems like it does a lot of processing after any key press. Is there anything I am missing or some other approach I should take?
<RadzenDataGrid @ref="dataGridControl" Data="@DataItems" Count="@ItemCount" LoadData="@OnLoadData" AllowFiltering="true" AllowPaging="true" PageSize="@PageSize"
FilterDelay="15000" AllowSorting="true" EmptyText="0 Rows Found" FilterMode="FilterMode.Simple" FilterCaseSensitivity="Radzen.FilterCaseSensitivity.CaseInsensitive" TItem="DashboardItem">