Java EE (Java Enterprise Edition) General Discussion

Hai friends,

I am able to paginate the out-put of a search... but the performance is very bad.I want the initial page, next and previous pages to be very fast. But the performance of all my pages is same(very slow and poor).
I am refreshing the page and performing the query once again. I have tried of getting only the 1st 50 records for page 1 from the database and the next 50 from the database once I click on the 2 nd page. Even then I am not able to improve the performance of the page (mostly due to no of database hits and as my database server is remote).I have fine tuned my query to the maximum possible extent and I don't think there is any problem with the query.
Now I want to know is whether there is any way that I may perform the query only once that is only at the first page and use the same result set in all the other pages.please don't say use result set as a session variable and use the same between pages... but suppose if i am having around 1000+ users accessing my application the load on the server would be enormous as I can't predict the number of records that will be fetched from a search condition (ie the space occupied by the result set object or result set values in a Vector can occupy very much space.
if suppose 100 users have fetched all the records( nearly 200000 records) then how can the server with stand that much memory).

Finally what I want is a method so that the number of database hits is 1 and the load on the web server is minimum when I use the pagination for my search tools.
keep in mind the performane of the tool is to be high....
Any solution is highly appreciated...
Thanks in advance...

regards,
ravikiran