Improve load speed with some specifics requirements

Delirium6

Hello,

I'm using Datatables for several years, but now i get a big problem of loading speed.
Usually, i load the DOM html table in php, but with 4000 rows it takes too much time 2min to 6 min it depends.
First things, i put this option to false : orderClasses, it increase the speed but not too much.

I need to get this at final, with all the specific thing in the table, id, classes, search in all the data etc...

So i see this to improve : https://datatables.net/faqs/#General-initialisation
I think i need to use this : Client-side processing - Ajax sourced data (ajax): ~50'000 rows. Speed options: deferRender
But i don't know if all will work like now (see screenschot) ?

There is a way to modify all the TD and cell to get the result like in the screenshot ?
Callback or other thing ? and the loading will be acceptable ?

Regards

colin

This section of the FAQ should help, it discusses various techniques to improve performance.

The column searching would work with serverSide, as would the edit button if you're using Editor.

Cheers,

Colin

Delirium6

Hi,

I tried with the deferRender option and ajax, for 6000 records i got 1min loaded, i think you're right i need ti use the server side option but many to work to get it.
I don't use the Datatable editor, i use manual editor with jquery.

Regards.