in reply to Re: DBI: How to update 150K records efficiently
in thread DBI: How to update 150K records efficiently
Thanks all for the helpful replies. :-)I've adjusted my code to:
my $sql = qq[
SET `va` = ?, `vb` = ?
WHERE `vc` = ?
while (my $record = <$input>)
my ($val1, $val2, $val3) = (split(/\|/,$record))[1,3,5];
$db->query($sql, $val1, $val2, $val3);
My question is: can we get the same 'prepare' effects as moritz mentioned in his post, since 'prepare' is done before the while loop..:)
BTW. thank you for your module, I've used it in most of my applications.