On Fri, Feb 2, 2018 at 10:16 PM, Stefan Adams <s1037...@gmail.com> wrote: > > > On Thu, Feb 1, 2018 at 6:42 AM, Sebastian Riedel <kra...@gmail.com> wrote: >> >> > I spoke with you about this briefly on Twitter, but just figured I'd put >> > it >> > out here, too. What about multiple record inserts on a single call? >> > Twitter thread. >> >> Yes, it's possible, not sure about how useful it would actually be though. > > > This makes sense! I'm able to do this below, which is all that I really > need: > > my $i = $pg->db->dbh->prepare('insert into b (first, last, birthday, age, > phone) values(?, ?, ?, ?, ?)'); > > my $results = $pg->db->select('a', [qw/first last birthday age phone/], > undef, {limit => $limit, offset => 1}); > > while ( my $next = $results->array ) { > > $i->execute(@$next); > > } >
in postgres you should be able, in case of inserting from one table to other: insert into b (first, last, birthday, age, phone) select first, last, ..., phone from a; and you save the whole round-trip of data. > FWIW, I ran a quick benchmark on 3 different algorithms to insert bulk data > into a database, and the method above was the fastest by far. Is there a > better / faster algorithm still to use for inserting bulk data? > > -- > 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. -- 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.