EjsGrid Query taking too much time for query data when row count is more then 12000

[Karan]

Hello,

I am using Blazor grid with GridTemplates approched.So actually I binnded two list<t> with this grid.

First Grid columns are  [AuditEntryID], [Name] and second templates grids column are [Id] [AuditEntryID] [OLDValue].

So when I click on first grid column then using  filter <EjsGrid DataSource="@auditEntryProperties" Query="@(new Query().Where("AuditEntryID", "equal", auditEntry.AuditEntryID))"> this show second detail grid data but now it's taking to much time for loading second grid. becase second list have 13000 rows so in filtering the data it taking to much time.

So have nay solution for this because 12000 data is not big deal any one can able to use this function and got the same issue like me.

Please attached screent shot for more details.

Thanks,

Karan

Attachment: Desktop_484fd123.7z

[Renjith Singh Rajendran]

Hi Karan, 

Greetings from Syncfusion support. 

We believe that bringing large amount of data in-memory is the cause of the slowness and also bounding grid with large amount of data without paging or virtualization will lead to slowness as it will use more memory. We could see that you are binding large data to Grid, at these cases it is recommended to enable paging for Grid to overcome the problem you are facing. With paging, Grid will load data and behave based on load on demand concept. Which will increase the performance of Grid. Please refer the below documentations and online demo for more details regarding this, 

Online demo : https://blazor.syncfusion.com/demos/datagrid/paging?theme=bootstrap4 

Documentation :   

https://blazor.syncfusion.com/documentation/datagrid/getting-started/#enable-paging 

https://blazor.syncfusion.com/documentation/datagrid/paging/ 

 

We have also prepared a sample with our latest version 18.2.0.48 based on your scenario, please download the sample from the link below, 

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/Serversample624556081 

Please refer the code below, 

<SfGrid DataSource="@Employees" Height="315px"> 

    <GridTemplates> 

        <DetailTemplate> 

            @{ 

                var employee = (context as EmployeeData); 

                <SfGrid DataSource="@Orders" Query="@(new Query().Where("AuditEntryID", "equal", employee.AuditEntryID))" AllowPaging="true"> 

                    ... 

                </SfGrid> 

            } 

        </DetailTemplate> 

    </GridTemplates> 

    ... 

</SfGrid> 

Or else you can also use the virtual scrolling feature of Grid to improve the performance of Grid when loading large data to Grid. Please refer the below documentations and online demos for more details regarding this topic, 

Online demo : https://blazor.syncfusion.com/demos/datagrid/virtual-scrolling?theme=bootstrap4 

Documentation : https://blazor.syncfusion.com/documentation/datagrid/virtual/ 

And also we could see that you are using an older version of Syncfusion Blazor package. As we have included several bug fixes and features in our latest release versions, we recommend you to upgrade to our latest Syncfusion Blazor package version 18.2.0.48. 

Nuget : https://www.nuget.org/packages/Syncfusion.Blazor/18.2.0.48 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran