Re: Taking advantage of prepared statement performance

From: Brett [mailto: brettonator@excite.com]
To: pgsql-jdbc@postgresql.org
Date: Thu, 10 Oct 2002 13:30:00 -0400 (EDT)
Subject: [JDBC] Taking advantage of prepared statement performance

I have a web application that invokes java jdbc code for each request. Would it be faster if I stored all my prepared statements for each connection, so when I want to do a query I a) pull a connection object from the pool then b) call ps.setX; ps.setY;...; ps.executeQuery(); and not close the prepared statement? That way, another thread could grab the connection and not have to recreate the prepared statement. I would associate sets of prepared statements with connections. Would this be faster than creating a prepared statement for each web request? I am using 7.1.3b2 (for production *crosses fingers*) in case that matters. Once again thanks for any help and sorry for any formatting issues with this message.