Re: DBD::Pg/perl question, kind of...

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Neal Clark <nclark(at)securescience(dot)net>
Cc: A(dot)M(dot) <agentm(at)themactionfaction(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: DBD::Pg/perl question, kind of...
Date: 2007-03-13 01:18:23
Message-ID: 87bqiyj600.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Neal Clark <nclark(at)securescience(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-13 01:30:12 Re: daylight savings patches needed?
Previous Message Benjamin Smith 2007-03-13 00:37:53 Re: How to enforce uniqueness when NULL values are present?