This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Performance and the fly likes Getting ResultSet very slow from the database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Performance
Reply locked New topic
Author

Getting ResultSet very slow from the database

chandubcs
Ranch Hand

Joined: Jun 03, 2001
Posts: 47
Hi all,
I am pulling up around 7500 records having just 3 DB fields using JSP/Servlets from Oracle DB. With the basic rs.next() and rs.getString(), its taking around 26 seconds to pull those 7500 records and I am storing those records in session for NEXT PREV links which is making application fast. But for the very first time, the time consuming is more. Is there any best way to get those 7500 faster, any suggestions like to use EJB's or Servlets ..
Thanks in advance,
Chandra
Jim Yingst
Wanderer
Sheriff

Joined: Jan 30, 2000
Posts: 18671
Please don't post the same question in multiple forums. Followups can go here. Thanks.


"I'm not back." - Bill Harding, Twister
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Getting ResultSet very slow from the database
 
It's not a secret anymore!