DataTable slow to render on data less than 5,000 records

olalekan

I have been battling with this for a long time now, I have different dataTables to show records, I have one . that contains over 30,000 records and it loads so fast, other ones does not and they have fewer records, at the first load, the one with 15k record takes about 1Min to load but when I search for anything, it takes nothing less than 2-5minutes to output any result whereas the one with over 30k record takes less than 4minutes to load. I have trimmed down my database query and even removed a lot of functions converting data on the fly in the foreach loop, still the same issues. I really don't know what else to do

colin

Hi @olalekan ,

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

Cheers,

Colin