Hi Cher Toggy,

With large data sets, we advice using load on demand either through scroll or paging. With load on demand with virtual scroll or paging, the initial load is the same as like loading 100 records – fast. Example with 100,000 records and virtual scroll with sort and filter enabled – https://www.htmlelements.com/demos/grid/virtual-scroll-sorting-filtering/. Similar example, but this time with Paging – https://www.htmlelements.com/demos/grid/virtual-paging-sorting-filtering/

Best regards,
Peter Stoev

Smart UI Team