Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
    Bookmark Topic Watch Topic
  • New Topic

Getting records very slow from the database

 
chandubcs
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Report post to moderator
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,
Chandra
 
Jim Yingst
Wanderer
Sheriff
Posts: 18671
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't post the same question in multiple forums. Followups can go here. Thanks.
 
    Bookmark Topic Watch Topic
  • New Topic