Large data volume datatables

Question

I am researching solutions to load a large volume of data on a page with Datatables and I would like to know if Datatables already have a function in which it will be ordering portions of data along with the server through an offset? (via Ajax request)?

Otherwise, you have some other solution to this case?

P.S.: I am looking for if anyone here has had such experience before making a method in the Front-end controller that will request portions of data together with the API until filling the total amount in the table.

Answer 1

Eai Brow, datatables is a great tool, but it is bad for use for large data volumes. So we developers use dynamic paging. Here is a tutorial from the Devmedia site that will help you create dynamic paging with the page in the URL using $_GET. For lack of information, I concluded that you are developing structured. However, if you have used frameworks like Symfony, Laravel, Codeigniter or others, they have components that greatly simplify the process. And finally, if you implemented via $_GET, you will easily be able to implement via Ajax.

http://www.devmedia.com.br/paginacao-em-php/21972

Answer 2

Have a look here: https://datatables.net/examples/data_sources/ajax.html

And here: https://datatables.net/reference/option/ajax