Faster search with serverside processing

Faster search with serverside processing

LouisNLLouisNL Posts: 1Questions: 1Answers: 0

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

This discussion has been closed.