hibernate - Paging And Sorting Repository And UI -

i have implemented pagingandsortingrepository , displaying domain object on ui using datatablejs.

i have pages , filters on table. problem facing doing findall() used return 100-200 rows, have been asked @ db increasing number of records 1million , retrieve data long.

my question how can achieve filtering on ui (among 1 million records) , pagination using existing components or should have re-write it? there examples out there?

with record set size need filtering on server side, have here starting point.

datatables send ajax calls on keystrokes containing search criteria has been entered , current page user viewing, , number of records display query string. can use info query db , send pre-filtered result set datatables render.