pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: V S P <toreason@fastmail.fm>
To: Andrew McMillan <andrew@morphoss.com>
Cc: pgsql-php@postgresql.org
Subject: Re: [Q] PDO use to bind arrays for insert
Date: Mon, 17 Nov 2008 03:55:55 -0500
Message-ID: <1226912155.25672.1285154419@webmail.messagingengine.com> (raw)
In-Reply-To: <1226910402.5577.280.camel@happy.mcmillan.net.nz>
References: <1226803530.24888.1284994985@webmail.messagingengine.com>
	<492093A5.7040606@gmail.com>
	<20081117002630.d86160fd.knl@bitflop.com>
	<1226890873.32288.1285117971@webmail.messagingengine.com>
	<1226894747.5577.267.camel@happy.mcmillan.net.nz>
	<1226896018.14093.1285127497@webmail.messagingengine.com>
	<1226910402.5577.280.camel@happy.mcmillan.net.nz>

Hi,
thank you very much 
the article you referenced is what I was looking for.




> 
> Prepared statements are per connection, and the actions taken at the
> close of a connection to pgpool to ready the pool for connection from a
> different client will very likely deallocate any prepared statements.
> The developers are usually actively trying to minimise pollution of
> state from one connection to the next, but persistence of prepared
> statements might be a different kettle of fish...
> 
> Read here for more information.  In paricular note that PREPARE has it's
> greatest impact when used on complex SQL - i.e. probably not INSERT
> statements:
> 
> http://www.postgresql.org/docs/8.3/interactive/sql-prepare.html
-- 
  V S P
  toreason@fastmail.fm

-- 
http://www.fastmail.fm - A no graphics, no pop-ups email service




view thread (7+ messages)

Message-ID: <1226912155.25672.1285154419@webmail.messagingengine.com>
Permalink:  ../1226912155.25672.1285154419@webmail.messagingengine.com/
Also on:    postgresql.org/message-id/1226912155.25672.1285154419@webmail.messagingengine.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: toreason@fastmail.fm, andrew@morphoss.com
  Subject: Re: [Q] PDO use to bind arrays for insert
  In-Reply-To: <1226912155.25672.1285154419@webmail.messagingengine.com>
  References: <1226803530.24888.1284994985@webmail.messagingengine.com> <492093A5.7040606@gmail.com> <20081117002630.d86160fd.knl@bitflop.com> <1226890873.32288.1285117971@webmail.messagingengine.com> <1226894747.5577.267.camel@happy.mcmillan.net.nz> <1226896018.14093.1285127497@webmail.messagingengine.com> <1226910402.5577.280.camel@happy.mcmillan.net.nz> <1226912155.25672.1285154419@webmail.messagingengine.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox