Postgres Pro
Downloads
Home   >   mailing lists

Question about DBCP prepared statement pooling with postgres - Mailing list pgsql-jdbc

From George Woodring
Subject Question about DBCP prepared statement pooling with postgres
Date
Msg-id 1B1B254441DB31448BD34C5BD73B0B8B28FD26@PHOENIX.istructure.com
Whole thread Raw
Responses Re: Question about DBCP prepared statement pooling with  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-jdbc
Tree view 
We are looking at implementing prepared statement pooling and I have a
question if it provides any gains with a heavily updated database.  I am
worried that the query plans will become stale an inefficient.

A coworker mentioned "jdbc prepared statement" != "psql or perl prepared
statement" and it is recommended for web environments (which we are).

Any suggestions would be appreciated.

Thanks,
Woody

----------------------------------------
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net

pgsql-jdbc by date:

Previous
From: "Jonathan Vallar"
Date:
Subject: Re: Bad Value for Data Type Timestamp
Next
From: Mark Lewis
Date:
Subject: Re: Question about DBCP prepared statement pooling with