From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | David Brown <dave(at)spoonguard(dot)org>, PostgreSQL Global Development Group <pgsql-patches(at)postgresql(dot)org>, Charlie Peck <charliep(at)cs(dot)earlham(dot)edu> |
Subject: | Re: Allow pooled connections to list all prepared queries |
Date: | 2004-12-26 03:11:00 |
Message-ID: | 41CE2BC4.4040000@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
> I don't see this as all that helpful for a client interface that does the
> preparation itself. Possibly it could be used for libpq, but you
> mentioned DBI which should already know what it has or has not prepared.
> The idea of adding a network round trip to detect a prepared statement
> seems like a performance loss, not a gain. If this is just to avoid
> repreparing the same statement then perhaps something like PREPARE OR
> REPLACE would be more useful.
Yes, PREPARE OR REPLACE was the other thing I thought would be useful.
However, in my example that still means preparing everytime, wasting the
benefits.
You could have:
PREPARE IF NOT EXISTS
:P
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-12-26 18:32:58 | MSVC compile errors |
Previous Message | Christopher Kings-Lynne | 2004-12-26 03:07:55 | Re: Allow pooled connections to list all prepared queries |