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

  *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 ) {


FWIW, I ran a quick benchmark
<https://gist.github.com/s1037989/2caa12379b733c7467c634e83f3331a7> 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.

Reply via email to