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: 63355

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
It's not a secret anymore!