aspose file tools*
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
Author

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

Thanks
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61654
    
  67

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] [Bear's FrontMan] [About Bear] [Books by Bear]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Retreive large records from database