On Sun, Feb 4, 2018 at 8:39 AM, sri <kra...@gmail.com> wrote:
> Almost. You do not want more than one active statement handle per
> connection. The while loop
> is pointless there anyway, because DBD::Pg does not support cursors. So
> all results will be sent
> to DBD::Pg as soon as you call $results->hash for the first time anyway.
> Better to use
> $results->hashes->each, which releases the statement handle and frees up
> the connection for
> inserts.

This helps a lot, thank you!  Am I following your suggestion correctly with

my $db = $pg->db;

my $tx = $db->begin;
$results->hashes->each(sub{$db->insert('b', $_)});

You received this message because you are subscribed to the Google Groups 
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mojolicious+unsubscr...@googlegroups.com.
To post to this group, send email to mojolicious@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.

Reply via email to