Re: DBD::Pg/perl question, kind of... - Mailing list pgsql-general

From Douglas McNaught
Subject Re: DBD::Pg/perl question, kind of...
Date
Msg-id 87bqiyj600.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: DBD::Pg/perl question, kind of...  (Neal Clark <nclark@securescience.net>)
List pgsql-general
Neal Clark <nclark@securescience.net> writes:

> comments?

Looks like the right idea.  If you have a lot of rows to process,
you'll benefit by fetching in batches, e.g.

my $sth = $dbh->prepare(qq{FETCH FORWARD 1000 FROM my_cur});

# iterate through the result set here....

-Doug

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: How to enforce uniqueness when NULL values are present?
Next
From: Tom Lane
Date:
Subject: Re: daylight savings patches needed?