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

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
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: 62272

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]
I agree. Here's the link:
subject: Retreive large records from database