DATATABLE TOO LONG TO LOAD 3.000 LINES - Performance help
DATATABLE TOO LONG TO LOAD 3.000 LINES - Performance help
JAIL_BOLSONARO
Posts: 2Questions: 1Answers: 0
in DataTables
My datatable is 3000 rows and is taking more than 1 minute to load the table in any browser.
I saw on the forum that using the command "deferRender": true I can gain in performance but I also see that it is necessary to file the Ajax command with an "ajax" font: "myrows.txt"
I would like to know how I can generate this Ajax from my MySQL base in order to implement the performance of my datatable.
thanks for the comprehension
This question has an accepted answers - jump to answer
Answers
You need to query the database and then you can just do
echo json_encode( $myData );to send it back to the client-side. This is an example showing how DataTables might then be configured to use such as JSON feed.Allan
Thanks, BRO!
I try this