Hi all,
first of all I would like to congratulate everyone within this list for
making it the most informative source of information regarding Servlets.
Now a question.
Does anyone know or can direct me to site which contains information on
optimising JDBC connections within a servlet and/or java bean.
We currently have a Java bean that connects to an AS400 db2 database using
JDBC. The Java bean is executed by a servlet. We have this working but the
response time between executing the sql request and displaying the results
is far too long - 2000 records with 4 string columns = 1 minute! We are
using connection pooling but it still doesn't solve the time lag problem we
are having.
We believe there are two major bottle necks:
1.the majority of the time is spent loading the resultset with the data
coming back from the AS400.
eg. ResultSet rs = stmt.executeQuery(query);
2.Another bottle neck is formatting the result set into objects with which
we can display the data on the JSP. For a solution we are thinking of
extracting only a certain amount of records eg 50 a time and displaying the
50. If the user requests the next 50 then we will extract it from the
resultset - cycle goes on until all results have been displayed.
Any ideas??
Best Regards
Marc
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
