JAVA : ZK framework Sorting and Manual Paging

I have created manual paging in list box. Also I have sort=("auto") for each header.But this sort makes 开发者_Python百科only on current page. I should make search on hole data.But on each page I am getting from database only 35 data. List box Auto paging works normal but it gets all data from data base and it makes very slow down.

You shall implement your own ListModel to load only the required data, rather than all. This small talk is a good reference.