Hi all, I have a servlet that executes queries against a database. The question I have deals with servlet multithreading: Is there any benefit in using the PreparedStatement class in doGet or doPost? eg. Prepared Statement sqlStatement = connection.prepareStatement(sqlString); >From what I remember the PreparedStatement class makes querying the database more efficient for every consecutive call after the first call. However in the servlet multithreading world each request is contained within its own thread. The PreparedStatement is created once for each thread. The statement is executed and the thread ends. There seems to be no reuse of the PreparedStatement object since each thread will create its own and destroy it. Is this correct?? 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
