Question about DBCP prepared statement pooling with postgres

From: "George Woodring" <george(dot)woodring(at)iglass(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Question about DBCP prepared statement pooling with postgres
Date: 2006-03-01 22:00:31
Message-ID: 1B1B254441DB31448BD34C5BD73B0B8B28FD26@PHOENIX.istructure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mark Lewis 2006-03-01 22:35:23 Re: Question about DBCP prepared statement pooling with
Previous Message Jonathan Vallar 2006-03-01 08:18:32 Re: Bad Value for Data Type Timestamp