>>>>> "Rob" == Rob <[EMAIL PROTECTED]> writes:
Rob> How can I speed it up some? I'm still new to database programming with
Rob> Perl so if you see anything else that I'm doing wrong or could do better
Rob> don't hesitate to point it out.
[...]
Rob> my $dbh = DBI->connect($database, $db_user, "",
Rob> {AutoCommit => 1},
Don't autocommit! Set AutoCommit to 0,
then $dbh->begin_work once at the beginning before your loop, and
$dbh->commit once after the end of your loop.
This should improve the speed tremendously.
Commit only when others need to see the updated database *at that
point* in time.
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[EMAIL PROTECTED]> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
