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();

    [download]
    becomes 
    my $insert = ...
  $insert->bind_param( ...
  ...
...

sub indexfile {
   ...
   $insert->execute();

    [download]
    you prepare once, you bind once, you execute many many many many times, like each time you update your bound params :)
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom