Java EE (Java Enterprise Edition) General Discussion

I have gathered that there is basically 2 ways to set up paging for result sets.
1) Put the data in a collection such as a Vector then cycle through the Vector.
2) By moving the cursor forward/backward in the database and re querying for each page.
Now my question is this, which way is best.
I am using MySQL 3.23-Max, Tomcat 4.1 Running on Redhat.
I have about 10 tables that contain an average of 35 fixed length columns.
We could have as many as 5000 concurrent users.

Any opinions on this topic would be greatly appreciated!
Or if anyone knows of a better/different way of paging resultsets I would greatly appreciate hearing from them.


Thanks

Gerald