Problems after update ejs-grid to 27.2.2

[Benjamim Goulart Bessa]

After updating ejs-grid from version 26.2.4 to 27.2.2 , I've encountered a performance issue. The component now takes longer to load records, and when I attempt to view 1000 records, the grid hangs and the browser displays a memory fault error. I've tried to use virtualization to improve performance, but I also need to maintain the ability to select records using checkboxes, which seems to be incompatible with virtualization.

What can I do?

[Pavithra Subramaniyam]

Hi Benjamim,

We understand that you are facing performance challenges while loading 1000 records in the Grid simultaneously.

This issue arises because of the large number of elements being rendered in the DOM (Document Object Model). Binding 1000 records with 6–10 columns result in approximately 21,000 to 35,000 DOM elements being generated. This substantial DOM load impacts rendering time, memory usage, and overall performance of the Grid. To maintain optimal performance, it is best to limit the number of rows and columns rendered at once.

Recommendations for Improving Performance:

1. Virtual Scroll or Infinite Scroll or Pagination:
   We recommend using on-demand rendering features like Virtual Scroll or Infinite Scroll or Pagination. These features optimize performance by rendering only the rows visible within the viewport, significantly reducing the DOM size and improving loading times. Based on your specific requirements, implementing one of these features can provide a noticeable performance boost.

Documentation for performance optimization:

https://ej2.syncfusion.com/vue/documentation/grid/performance

Our EJ2 Grid’s Virtual Scroll feature is compatible with the checkbox selection functionality. When using Virtual Scroll or Infinite Scroll with the persistSelection property enabled, please note the following:

• For local data: Clicking "Select All" will select all records in the Grid.
• For remote data: Clicking "Select All" will only select the records currently loaded in the viewport, as the feature works on an on-demand loading basis.
  This is the default behavior of the Grid’s persist selection mechanism when handling remote data.

If you encounter any issues while using this combination, please share additional details such as:

• The specific feature combinations configured in your Grid.
• A description of the issue, along with supporting materials like screenshots, videos, or script error messages.
  This information will help us identify the root cause and provide a tailored solution as quickly as possible.

Regards,

Pavithra S

[Benjamim Goulart Bessa]

Hi Pavithra,

Version  26.2.4 was smooth sailing for me, but in version 27.2.2, I'm encountering a grid hanging issue when I try to load 1000 records. This is a significant hindrance to my work and it's a problem I've never faced before, impacting my productivity and the quality of service I can provide.

To explain me better, I have 10,000 records, and working with pagination, the default value of records per page is 50, but when I try to change it to 1000, the grid hangs, even using virtualization, that behavior hasn't occurred before.

I really need your expertise here. Because my clients are starting to get a bit impatient, I've had to roll back to version 26.2.4. Any help you can provide would be greatly appreciated.

I made two videos: one with enableVirtualization:true and other with enableVirtualization:false​​, please, if is possible, access then in link bellow:

https://1drv.ms/f/s!Aou0WzzgCeAHm59z3oZO0Ug8KSZ-sg?e=JihPtv

Ps.: I put another video to show the grid behavior in version 26.2.4

[Aishwarya Rameshbabu]

Hi Benjamim,

Please follow up on the ticket created under your Syncfusion account for further updates regarding your query.

Regards,

Aishwarya R