Smart search not working with server side implementation

spidogr

I presume that smart search is the default, and, if for example the table contains a cell with:
Junior Technical Author

Then simply entering Junior Author will bring it up. However, this does not seem to be the case with server side implementation (mysql). Am I missing something?

https://datatables.net/examples/server_side/simple.html

kthorngren

Smart Search is a client side function. When using server side processing your server script is responsible for searching. If you are unable to use client side processing then you will need to implement smart search functionality in your server's MySql queries. Do you have many thousands of records that require server side processing?

Kevin

spidogr

I am considering a test case scenario with at least 1 million and then scale up to 10+ million (mostly tables with two columns, but with record length varying up to 1000 characters). Not sure whether datatables approach would be appropriate for that resource- and performance-wise or not even whether MySQL is the right candidate and I should consider Elasticsearch or something. I am definitely open to suggestions.

I did find this post which appears to add regex to server side approach: https://datatables.net/forums/discussion/36652/server-side-column-filtering-with-regular-expressions-regex