Re: [Q] PDO use to bind arrays for insert

On Sun, 2008-11-16 at 22:01 -0500, V S P wrote:
>
> I think Chris @ dmagick pointed to a raw string functionality
> that -- so I will need to figure out if
> a) it actually saves on parsing

Using the COPY functionality in PostgreSQL does save on parsing,
although an insert of many rows in a single insert statement doesn't
spend any significant amount of it's time parsing the input, and the
query planning only happens once.

If you are really concerned about the performance impacts of an insert,
you might be better advised to feed the row data to a separate process
which handled the actual inserts.

> b) if it will work with PG connection pooling (which I am not
> using yet, but will in the future).

There's no reason why COPY shouldn't work with connection pooling,
unless your connection pooling is trying to understand the statements
deeply on the way through, without understanding PostgreSQL. I can't
think of why someone would write connection pooling that way though!

Certainly it will work fine with pgpool, which is what I would recommend
for connection pooling with PostgreSQL as it is written by someone on
the core team.

Cheers,
Andrew McMillan.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
You have a deep interest in all that is artistic.
------------------------------------------------------------------------