Datatables velocity array >10000 regs

pepitovadecurt

Hi I have a PHP program that returns an array with >10000 lines in most cases.
To show the regs to datatables use foreach and echo to write every regs.
Using ajax or something to transfer the regs from PHP to datatables maybe it runs with more speed?
Thanks.

allan

Yes - it should run faster as you could enable the deferRender option to reduce the initial draw time. See the speed FAQ.

Allan

pepitovadecurt

Hi allan, the problem is the php time to return data. Now trying server side and post the results here.
Thanks.

pepitovadecurt

I think I'm not in correct way. My app structure is:

 index.php ---> collect the vars data
 output.php ---> show the calculated data
    ^^ output.class.php ---> calculate the data and return array to output.php

Need the server side? Need to save to a database?
I want to show loading or calculating in the datatables because sometimes the calculation takes too long.

allan

processing will show a processing message when DataTables is busy.

Allan