Don't send request to server, while clicking on sorting in datatables

inquisitive_stha

I am using the serverside data table, but it looks taking more time to fetch data from the server if we also use order by option. So, what I want is fetch 50 data.

1) And I want data to be sort only on the client side, sort it in order from the first column only among those 40 data.
2) When I click to order it in descending, still don't send the request to the server just sort among those 50 data
3) Same will implies if we try to other column. I won't send any request.
.

colin

Hi @inquisitive_stha ,

That's not possible I'm afraid - if you're using serverSide, then all operations that would cause a draw are sent to the server. It would be worthwhile diagnosing why it takes so long to fetch the data, if your scripts and database are optimised, it should be quick for even the largest dataset.

Cheers,

Colin