in reply to Re: XML::Twig to mysql totally lost
in thread XML::Twig to mysql totally lost

so $insert->bind_param( 1, $path, 2, etc, 3, etc, 4 etc, 5, etc, etc, etc); ??

Replies are listed 'Best First'.
Re^3: XML::Twig to mysql totally lost
by Anonymous Monk on Jul 15, 2011 at 09:14 UTC
    Um, I said move, not rewrite :) Move as in
    my $insert = ... ... sub indexfile { ... $insert->bind_param( ... ... $insert->execute();
    becomes
    my $insert = ... $insert->bind_param( ... ... ... sub indexfile { ... $insert->execute();
    you prepare once, you bind once, you execute many many many many times, like each time you update your bound params :)