Java – ZK: Design Pattern: looking for large amounts of data?

I'd like to make some suggestions on how to deal with paging and sorting of large amounts of data

At present, I retrieve all user data and paste it in the list box This is very good, but when we have 100000 users, I don't want to fill in the list box with 100000 users, and I don't want to have a collection of 100000 users on the server

Would you recommend a good way to do this?

I should keep the connectedrecordset and pass it to the list box Does ZK have the ability to manage data and connections?

~ or ~

Is it better to manually find page events and refill the list box with a second set of data, pulling only 10 rows at a time?

In addition, when I want to allow users to sort by column, I certainly need to re query the data in the database

What is the right way to challenge this? Please provide suggestions or article links

thank you,

sign

Solution

You can view the tutorials of sorting huge data using ZK and handling huge data using ZK