Hi Scott,
Thanks for contacting Syncfusion support.
Based on your query, we could see that you are rendering more number records to the grid at a time. We would like to let you know the behavior of EJ2 Grid.
When you rendering large number of records with column template feature then Grid will take considerable time render whole records in DOM and it leads performance issue. You can avoid this by using following feature (Paging, Virtualization, InfiniteScroll) of Grid which works based on on-demand concept and maintains current page records only in the DOM. It improves the Grid performance.
** Paging **
Paging provides an option to display Grid data in page segments. To enable paging, set the
allowPaging to true. When paging is enabled, pager component renders at the bottom of the grid. Paging options can be configured through the
pageSettings.
** Virtualization **
If you want to load large amount data without using paging feature, you can use Virtualization feature. It allows you to load large amount of data without performance degradation.
Row virtualization allows you to load and render rows only in content viewport. It is an alternative way of paging in which the data will load while scrolling vertically. To setup the row virtualization, you need to define
enableVirtualization as true and content height by
height property.
** Infinite Scrolling **
Infinite scrolling is used to load a huge amount of data without degrading the Grid performance. This feature works like the lazy loading concept, which means the buffer data is loaded only when the scrollbar reaches the end of the scroller.
You can use any of this feature based on your requirement.
** Data Binding **
The Grid uses
DataManager, which supports both RESTful JSON data services binding and local JavaScript object array binding. The
dataSource property can be assigned either with the instance of
DataManager or JavaScript object array collection. It supports two kinds of data binding method:
You can choose the data-binding based on your data base.
Please get back to us if you need further assistance with this.
Regards,
Rajapandiyan S