Pagination with search

JS datables is great, but depending on what kind of clients are running your front end, it can be an issue. It won't matter with a small set of data, but I've had to switch away from datatables on a few occasions because it can absolutely rape some browsers.

That's a good point, I always wondered what the performance would be on a significantly large dataset. What browsers have you had issues with, I'm assuming it is earlier version of the dreaded Internet explorer?

There are no issues if you do it right. Can you elaborate on "a few occasions because it can absolutely rape some browser"?

Choose server processing, create the correct queries and you are fine. Even with millions of records.