http://www.perlmonks.org?node_id=677561


in reply to Re: DBI: How to update 150K records efficiently
in thread DBI: How to update 150K records efficiently

Oh, but the OP's code also uses a cached prepared statement. DBIx::Simple handles this internally. The problem is that before it can access the cache, it has to generate the query string all over :)

Juerd # { site => 'juerd.nl', do_not_use => 'spamtrap', perl6_server => 'feather' }

  • Comment on Re^2: DBI: How to update 150K records efficiently