Re: general PG network slowness (possible cure) (repost) - Mailing list pgsql-performance

"Also sprach Richard Huxton:"
> > scheme each time, for example!  (how that?). I could presumably also
> > help it by preloading the commands I will run and sending over the
> > params only with a "do a no. 17 now!".
>
> PREPARE/EXECUTE (or the equivalent libpq functions).

Yes, thank you. It seems to speed things up by a factor of 2.

But can I prepare a DECLARE x BINARY CURSOR FOR SELECT ...  statement?
The manual seems to say no.

Peter