I see a lot of applications using datatables, I would like to use it too because you get a lot of nice controls out of the box and also without having to request the server with every interaction. However, in order to get this working you need to retrieve the full set of records at once, right? Isn't this horrible performance wise? Am I missing something?
datatables allows you to do it either way depending on your requirements. If its a few hundred records, send it all at once and page search and filter in the client, if it will be more than that you can split it so that records are loaded on demand from the backend