How to Optimize jQWidgets Grid Performance for Large Data Sets?

[jameswood32Participant]

Hi all,

I’m using the jqxGrid component from jQWidgets to display large datasets (10k+ rows), and I’ve noticed some lag when scrolling or sorting. Are there any built-in performance settings or best practices for optimizing grid speed with massive data?

Also, is virtual scrolling or data paging more efficient in this case? Appreciate any real-world tips!

[adminKeymaster]

Hi jameswood32,

For large data sets, the scrolling speed is the same. The only slower thing is the initial data binding and when you apply a filter, sort. This can be observed in this example https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/largedataset.htm?fluent which is with 30,000 rows.
In the case of Filter, Sort, the larger the data set is, the slower these operations would be. In this case, we suggest you use virtual data i.e the Grid shows and loads data on demand while you scroll or change pages. Alternatively, you can try our Smart.Grid from htmlelements.com which is more advanced in such scenarios and handles larger data sets, client side.

Best regards,
Peter Stoev

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

[Author]

Posts