Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #103275
    Cher Toggy
    Participant

    Hi,

    I am evaluating the use of DataGrid for large sets of data. I was wondering if the are some benchmarks and/or pointers on how to best handle large data in the grid.Specifically,
    – Is it possible to handle initial loads of about 400mb of read-only records and the preferred efficient way of doing so?
    – If we don’t need modification, only filtering and searches – is it better to utilize tables vs. grids in this case, or the tradeoff is negligible?
    – Is there an example showing how a virtual datasource on a grid works in terms of improving performance on a large initial load.

    Thank you!

    #103276
    admin
    Keymaster

    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
    https://www.htmlelements.com/

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.