About duckbill

William Blunn is a Perl Developer on the Website Merchandising team at Net-a-Porter. He first used Perl in 2000, becoming a full-time Perl Developer in 2009.
Open Source

DBIx::MultiRow – Updating multiple database rows quickly and easily

A requirement arises in many systems to update multiple SQL database rows. For small numbers of rows requiring updates, it can be adequate to use an UPDATE statement for each row that requires an update. But if there are a large number of rows that require an update, then the overhead of issuing large numbers of UPDATE statements can result in the operation as a whole taking a long time to complete.

Continue reading