Re: Slow network retrieves

On 5/9/04 1:58 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> I am not sure how either of these techniques map into ecpg though.
> If you want to use ecpg then I'd suggest bringing up the question on
> pgsql-interfaces --- the ecpg gurus are more likely to be paying
> attention over there.

I got some sample code from someone on the pgsql-interfaces list on how to
do bulk FETCH's. It is pretty much the same as with Pro*C. You just can't
use that for INSERT/UPDATE (hint, hint...) I was able to improve the
network retrieval rate from 1 million records per hour to 1 million records
per minute.

Wes