Datatable filter huge amount of datasets

Motteeer

Hello,

we have a huge amount of datasets which should be filtered by users. So we decided to implement the server-side approach.The SQL-Statement fetching the data from the MySQL-database is very complex and probably quite slow.

I´m wondering that it´s not possible to load the data once to the client-side and do all the filering stuff there. Because filtering on server-side based on this fetching approach with ~250.000 rows of data is really too slow. Or am I missing something?

Thanks in advance.