Does the grid virtualisation really virtualise the data from the database

[Craig]

I'm looking for more information and a little reassurance about the virtualised grid. 

I am using Entity Framework and like the concept of the virtual grid. I note, however, that the grid requires a List<objecttype> from which to work, and the example uses a service to load the List with items from the database, which is then virtualised regarding rendering on screen. This means that the data retrieval from the database is not virtualised, just the lines which are displayed on screen. 

I suppose this is okay for modestly sized data table. I added 7,000 items into a table and it was still quite fast. What if we had 2,000,000 records? We would not want to load all of them at once and that is where data recovery virtualisation is needed.

Have I misunderstood what is happening? Is there a way to virtualise the data extraction - which should also be able to extract while taking sorts and filters into account?

I look forward to hearing how this works.

Rehgards

Craig Sheppard

[Renjith Singh Rajendran]

Hi Craig, 

 

Greetings from Syncfusion support. 

 

Based on this scenario, we suggest you to bind data using custom way of binding in grid. Now you can customize the data operations based on your requirement inside Read method of CustomAdaptor. You can inject your dbcontext in Read method and assign the dbcontext to DataSource in Read method. The DataOperations class methods will perform the data operation actions based on the IEnumerable data and fetch the data based on DataManagerRequest’s Skip and Take. 

References : 

https://blazor.syncfusion.com/documentation/datagrid/custom-binding 

https://blazor.syncfusion.com/documentation/datagrid/custom-binding#inject-service-into-custom-adaptor 

 

Please get back to us if you need further assistance. 

 

Regards, 

Renjith R 

[Craig]

Thanks Renjith, I see the direction I need to try now. I'll examine that and get back if I get stuck again. 

Best Regards

craig 

[Renjith Singh Rajendran]

Hi Craig, 

 

Thanks for your update. Please get back to us if you need further assistance. 

 

Regards, 

Renjith R