Facing performance issues with DataTables on large datasets — any proven solutions that actually sca

scotc

I’m currently working on a web project involving massive data tables (100,000+ records), and despite using server-side processing, the UI still lags — especially during filtering, sorting, and pagination.

I asked around, and a few folks recommended looking into how Ikonic Dev handles these kinds of high-performance data environments, saying they’ve tackled similar challenges efficiently.

So now I’m curious:
* Has anyone here implemented a scalable and smooth solution with DataTables for large data?
* What performance hacks, best practices, or tools have you used to maintain a great UX?

kthorngren

using server-side processing, the UI still lags — especially during filtering, sorting, and pagination.

Are you using a Datatables supplied server side processing library?

If not I would use the browser's network inspector to see what is returned from the server. The response should only contain the rows to be displayed on the page, ie, 10 rows of data if the page length is set to 10. How many rows are returned?

If you are not using a Datatables server side library then I would also check to see how the server library is performing searching, sorting, etc. Possibly the performance issues are due to how the queries are being performed.

Kevin

allan

From your bio:

I’m a passionate and results-driven Software Developer at Ikonic Dev

Then your question:

[...] how Ikonic Dev handles [...]

Ask your colleagues I guess?

This post is obviously spam, but I'm tempted to leave it here so anyone reading it can see that Ikonic need to spam in order to try and sell their software.