title: filter pagination sorting at frontend or backend
body: <p>I have an application mostly display table data from database. but those tables need to be applied pagination, sorting, filter. for sorting and filter, they needs to be applied on the whole list, not only 1st. page.
  I have 3 ideas in my head:</p>
  
  <ul>
  <li>retrieve the whole list from backend, and then apply pagination, sorting, filter on frontend using javascript. (this way is very easy and I found a lot libs can do it).</li>
  <li>do sorting, pagination, filter on hibernate level.(ie. create dynamic SQL to get result and then using AJAX call render to frontend.)</li>
  <li>do sorting, pagination, filter on java level. (ie. get the whole list from database and then using Spring PagedListHolder do pagination and sorting, maybe other framework for filter. and then again using AJAX call render to frontend.)</li>
  </ul>
  
  <p>which way is best to achieve this amount those three?
  or there is other better way that I didn't think.</p>
  
  <p>Thanks for any help or tip.</p>