In my Perl code, I am now using DBIx::Simple to connect with my Database.. To update a bunch of records saved in a file, I just loop through each line in the file and update records one by one.
while (my $record = <$input>)
my ($val1, $val2, $val3) = (split(/\|/,$record))[1,3,5];
my %data = (
va => $val1,
vb => $val2,
my %where = (
vc => $val3,
$dbh->update('myTable', \%data, \%where);
This works quite slow. Is there any better way in DBIx::Simple or any other easy-to-use DBI ways/models to implement fast update of many records(i.e. 150K records, the table contains totally 200K records). thanks..