File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes Retreive large records from database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Retreive large records from database" Watch "Retreive large records from database" New topic

Retreive large records from database

ravisha andar
Ranch Hand

Joined: Feb 25, 2011
Posts: 55
Hi All

What is the best way to fetch aroung 10000 records and display it in a jsp table

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63837

The best way is not to. That's way too many records to display to a user at once. Page the date, or otherwise allow the user to provide filters to bring the dataset down to a reasonable size.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Retreive large records from database
jQuery in Action, 3rd edition