Neal Clark <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to