Optimize grid export

Hello.

I have a Grid that might have millions of rows, and when I export it to Excel, this process takes more than an hour.

My question is: what can I do to optimize the export process? What do you guys suggest?

I appreciate any help!


1 Reply

PS Prathap Senthil Syncfusion Team November 27, 2024 03:54 PM UTC

Hi Guilherme Cremasco,

Based on the reported problem of exporting million records, we were unable to reproduce the issue using the latest version, 27.2.4. You mentioned that the process takes more than an hour, but we could not replicate it. Kindly refer to the export testing times below for reference:


Exporting time:

Test 1: 0h 0m 47s 114ms

Test 2 : 0h 0m 40s 451ms

Additionally, we would like to clarify that if you are using a foreign key column in the grid, we have improved the performance in version 27.2.3 of the Essential Studio for Blazor Weekly NuGet Release. Please see the release notes for further details.Essential Studio for Blazor Weekly Nuget Release Release Notes


If you are still experiencing issues with Excel exporting performance in the grid, we require some additional information from you to proceed. Please share the following details:


  • A grid code snippet along with the model class.
  • A simple, reproducible sample of the issue with sample data.
  • If possible, please share any attempts you made to reproduce the reported issue using the attached sample.

The above details will be very helpful in validating the reported query on our end and providing a solution as soon as possible. Thank you for your understanding.

Regards,
Prathap Senthil


Attachment: BlazorDataGrid_ddc73825.zip

Loader.
Up arrow icon