Slow data loading

Slow data loading

kali83kali83 Posts: 18Questions: 0Answers: 0

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...

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,055 Site admin

    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

  • kali83kali83 Posts: 18Questions: 0Answers: 0
    edited January 2022

    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

  • colincolin Posts: 15,118Questions: 1Answers: 2,583

    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

Sign In or Register to comment.