Slow data loading

kali83

Hi all,
datatable to load about 7000 rows takes about 3 seconds. The duration of the API execution in php is about 135/150 ms.

Is it possible to improve or fix?

Thanks for your help...

allan

Have you read this FAQ?

If so, and it doesn't help, please link to a test case showing the issue so we can offer some help.

Regards,
Allan

kali83

Thanks for the guide. I read....

I have both scroll X and Y other settings like columnDefs with {"className": "dt-center",
"targets": "_all"
},
{
"targets": [2],
"visible": false,
"searchable": false
},

I just added this property: "deferRender": true and loading has improved a lot.

At the tatatable i pass the source via the "data" option: json.data.
The json.data is callback

Is there anything else i can do?

Thank you

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin