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
posted 12 years ago
Please don't post the same question in multiple forums. Followups can go here. Thanks.