On 5/9/04 1:58 PM, "Tom Lane" <tgl@sss.pgh.pa.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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
