Custom EventList for huge datasets?

Hi,

I'm working on a client-server application and I use several virtual SWT tables to display the data from the database. Since the application will handle huge datasets (over 50.000), I was thinking about improving the performance even more.

Right now I load the whole data at the start of the application which result in fast sorting/filtering but the initalization of the table is rather slow. I have even implemented a "paging" concept by using RangeList.

I was thinking about creating a custom EventList that would query the database only for the necessary rows. This would even apply for filtering and sorting.

Has anyone suggestions for my problem? Or maybe does something similar already exist?

Thank you in advance,
Daniel