Pooling Prepared Statements

From: "G(dot)Nagarajan" <gnagarajan(at)dkf(dot)de>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Pooling Prepared Statements
Date: 2002-08-29 17:11:17
Message-ID: NFBBIOPECKPCJJHHBOGJAEKEDGAA.gnagarajan@dkf.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi,
i am planning to implement a pooling system for Prepared Statements.
It will open a single connection during initialization and create
many prepared statements using this connection. The connection will
be always kept open so that the prepared statements are valid. To
speed up things, there may be more than one prepared statement for
the same query, ie,

stmt1 = "select from table where field = ?";
stmt2 = "select from table where field = ?";

Will there be any issues when two statements are executed for the
same table using the same connection? has anyone tried doing something
like this or is there any open source tool which can do this?

This will greatly improve the efficiency of the system as most of the time,
the connections are used for executing the same statements. Pooling the
statements instead of the connection will save the processing needed
for creating the statement objects for every query.

Regards,
Nagarajan.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message João Paulo Caldas Ribeiro 2002-08-29 17:44:32 Re: Pooling Prepared Statements
Previous Message Tarik Choufa 2002-08-29 16:42:04 JDBC sources