Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?

* Florian Weimer (fweimer(at)bfk(dot)de) wrote:
> * Stephen Frost:
> > Actually, can't you stick multiple inserts into a given 'statement'?
> > ie: insert into abc (123); insert into abc (234);
>
> IIRC, this breaks with PQexecParams, which is the recommended method
> for executing SQL statements nowadays.

For prepared queries you're absolutely correct. It's also true that
it's the recommended approach for large numbers of inserts. If the
network delay is more of a problem than the processing speed then it
might make sense.

It does seem to me that with multi-value insert we might consider
changes to libpq to be able to use multi-value prepared inserts... Or
it might be interesting to see the performance of non-prepared
multi-value inserts vs. prepared statements.

Thanks,

Stephen