Faster search with serverside processing
Faster search with serverside processing
I am using Datatables with 1.5 million records. We are using server side processing and this is going great. Now we have some issues with the search option in the table. If we make a search its takes to long before the results are displayed in the table. We are using these statements:
"processing": true,
serverSide: true,
ordering: false,
"bSortClasses": false,
"sAjaxSource": "client/XXXXXX.php",
stateSave: true
What can we do to speed up the search after the data is loaded in the tables?
Thnx in advance