Datatables server side faster Indexing

imacoolguyful

I have a datatable with server sided processing and about 60k entries. It is pretty fast but can sometimes be slow depending on the search criteria. I was wondering if there are any tricks to make the server sided indexing faster. I was not able to find anything on google. Sorry if this is a silly question.

colin

There are a few threads, like this, that may help. Otherwise, it'll be standard dbops stuff , maybe try indexing the columns you'll be search against the most, for example.

Colin