locked
best DataTable for Vanilla JS RRS feed

  • Question

  • User-590375999 posted

    I am using DataTable JS in my spa, i enabled fixed columns and loading 50000 records, datatable js takes long time to load and make html hang. 

    any fast loading javascript datatable with fixed column feature ?

    Wednesday, May 20, 2020 1:05 PM

Answers

  • User-474980206 posted

    Just use the scroller data option.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 21, 2020 2:33 PM

All replies

  • User-474980206 posted

    There is no table that can display 50000 records fast. Instead they implant a virtual scroll. Datatables also has this feature

    https://datatables.net/extensions/scroller/

    Wednesday, May 20, 2020 2:53 PM
  • User1535942433 posted

    Hi sivapooja,

    Accroding to your description,as far as I think,you could speed up datatable running.

    There are several ways in which you can speed up DataTables. Often the first thing to do is enable paging (paging)  as this simply reduces the amount of data to be displayed. Its also worth noting that scrolling (scrollX and scrollY) can have a significant impact on draw performance for tables with lots of columns, due to the calculations involved. Beyond that, the method you are using for loading the data will typically have the most significant impact on performance.

     If you are working with seriously large databases, you could consider using the server-side options that DataTables provides. 

    More details,you could refer to below articles;

    https://datatables.net/faqs/#speed

    https://www.datatables.net/examples/server_side/simple.html

    Best regards,

    Yijing Sun

    Thursday, May 21, 2020 2:38 AM
  • User-590375999 posted

    Hi,

    I am using the Scroll and fixed column feature , the scroll cause the slowness.

    i don't want to call server side ( web service ) each time, can i use  ( scroll +  Local json object ) ? 

    Thursday, May 21, 2020 2:50 AM
  • User-474980206 posted

    Just use the scroller data option.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 21, 2020 2:33 PM
  • User-590375999 posted

    Hi,

    After added this setting the loading time is improved, i am facing another issue , when i rebind the filtered data , it takes more time to rebind. i added this setting to destroy existing data.

     "bDestroy": true,

    Initial loading data : 15000 records ( 30 seconds )

    rebind with filtered data : 2 records ( 1 minute 10 seconds )

    How can i improve the rebind time ?

    Monday, May 25, 2020 5:57 AM
  • User-590375999 posted

    Hi bruce can you please reply

    Friday, May 29, 2020 12:08 PM