DataTables ajax data refresh too slow
DataTables ajax data refresh too slow
I'm using DataTables to display about 1000 rows.
- Content is being fed to the DataTables via ajax.
- Client-side processing (serverSide: false).
Each table redraw that happens every 10s ( table.ajax.reload(null, false); ) makes the web-page freeze for about 1s which is already noticeable by users. An ajax data http-request takes only about 110-130ms and consists of 15-16 KB of data. The users' hardware is not outdated, these are Intel i5 corporate Dell laptops with at least 4 GB of RAM each.
The issue is noticeable in both cases when using pagination mode (pagingType: "full_numbers") and scrolling mode (scroller: { displayBuffer: 300 }), however, it looks slightly less awful in the pagination mode.
It looks like the problem is hidden here:
My questions is:
- Is it possible somehow to make the redraw of DataTables ajax data faster? Any magical option I missed? Enabling server-side processing or implementing Web-sockets? Or digging deeper into the DataTables code and trying to enhance it?