autorowheight and large pagesize trash grid performance.

[pkParticipant]

This occurs on version v11.0.1.
Create a grid with a local data array of 10 rows.
Set pagesize to an arbitary large number, let’s say 5000.
Grid renders normally, CPU usage minimal.

Now keep the pagesize to 5000 and set autorowheight: true.
Grid is unresponsive, CPU 100%.

This is because autorowheight will insert 5000 DIVs in the dom, even if data only contains 10 rows.

[adminKeymaster]

Hi pk,

The behavior you are experiencing is normal. autorowheight expects autoheight to be true, too. This means that the built-in UI Virtualization is turned off in this mode and the Grid has to create HTML Elements for each Cell. If you want to display many rows in your Grid, you will have to skip the autorowheight.

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[pkParticipant]

I get that it’s designed this way, and you may not want to change it.
However, from a user point of view, having a huge performance penalty with just 10 rows of actual data (or even with no data at all) is not “normal”.

I think an easy improvement would be to warn the user like this:
If autorowheight MUST have autoheight equal to true, then the grid should throw an error if those parameters are not both equal to true or both false.

[adminKeymaster]

Hi pk,

It already throws an error when autorowheight is set to true and autoheight or pageable is not. It is also explained in the API DOCS of the Grid about “autorwoheight” – “This property works along with the “autoheight” property. When it is set to true, the height of the Grid rows is dynamically changed depending on the cell values.”

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[Author]

Posts