Last post May 29, 2020 12:08 PM by sivapooja
May 20, 2020 01:05 PM|sivapooja|LINK
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.
May 20, 2020 02:53 PM|bruce (sqlwork.com)|LINK
There is no table that can display 50000 records fast. Instead they implant a virtual scroll. Datatables also has this feature
May 21, 2020 02:38 AM|yij sun|LINK
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;
May 21, 2020 02:50 AM|sivapooja|LINK
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 ) ?
May 21, 2020 02:33 PM|bruce (sqlwork.com)|LINK
Just use the scroller data option.
May 25, 2020 05:57 AM|sivapooja|LINK
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.
Initial loading data : 15000 records ( 30 seconds )
rebind with filtered data : 2 records ( 1 minute 10 seconds )
How can i improve the rebind time ?
May 29, 2020 12:08 PM|sivapooja|LINK
Hi bruce can you please reply