in reply to Re^3: How to Do multiples SQL Insert at one time?
in thread How to Do multiples SQL Insert at one time?

Alternatively, let someone else separate preparation and execution! 

use DBIx::Simple;
my $db = ...;

while (<$log>) { 
    $db->query('INSERT INTO foo VALUES (??)', split /:/);
}

[download]
This prepares the query only once.

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

In Section Seekers of Perl Wisdom