http://www.perlmonks.org?node_id=410340


in reply to Re: Pearls (not really) of Perl programming
in thread Pearls (not really) of Perl programming

Plus, depending on the number of lines in the INFILE, you probably swamped the DB by not keeping the $dbh outside of the while.

Replies are listed 'Best First'.
Re^3: Pearls (not really) of Perl programming
by radiantmatrix (Parson) on Nov 25, 2004 at 13:43 UTC

    Quite. Not to mention that particular app connected to a mysql instance that was about 5 router hops away over not-the-fastests links. Connect times averaged 5s, which really reared its ugly head when the input file was 2_000 lines. ;-)


    radiantmatrix
    require General::Disclaimer;
    Perl is