wood burning stoves 2.0*
The moose likes Java in General and the fly likes Getting records very slow from the database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Reply locked New topic

Getting records very slow from the database

Ranch Hand

Joined: Jun 03, 2001
Posts: 47
Hi all,
I am pulling up around 7500 records having just 3 DB fields from JSP using Oracle thin driver in Websphere 5 from Oracle 8.1.7. It is taking around 26 seconds to pull those 7500 records, I am storing those records in session for NEXT PREV links which is making application fast later. 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 ..
I appreciate your help
Thanks in advance,
Jim Yingst

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
Don't get me started about those stupid light bulbs.
subject: Getting records very slow from the database
Similar Threads
Delay in JDBC ResultSet
How to retrieve partial data in SQL Server ?
Certification Preparation
Getting ResultSet very slow from the database
oracle pagination query for bulky data