DATATABLE TOO LONG TO LOAD 3.000 LINES - Performance help

JAIL_BOLSONARO

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

AND #OUTBOLSONARO #JAILBOLSONARO

allan

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

JAIL_BOLSONARO

Thanks, BRO!

I try this