in reply to XML::Twig loves to eat my memory

I think you need an

 $sth->finish;

and probably a

 $dbh->disconnect;

Replies are listed 'Best First'.
Re^2: XML::Twig loves to eat my memory
by carcus88 (Acolyte) on Jul 22, 2010 at 20:06 UTC
    $sth->finish() has no effect since $sth->fetchrow_hashref() is an while loop. When sth reaches end of recordset it effectively calls sth->finish(). The DBI docs back this up.
[reply]

In Section Seekers of Perl Wisdom