Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: Re: Re: Re: Perl memory Memory consumptionby alfatux (Novice) |
on Nov 26, 2001 at 20:19 UTC ( [id://127559]=note: print w/replies, xml ) | Need Help?? |
Hi, No, with process_msg the program not gows. I've investigating more an I detect that the problem could be in the get_msg funtion that looks like: sub get_msg { my $self = shift; my ($param) = @_; my $consulta_stack = qq{ SELECT * FROM out WHERE app = $param ORDER BY id DESC LIMIT 100; }; my $sth = $self->{dbh}->prepare($consulta_stack); $sth->execute(); my $msgs = $sth->fetchall_hashref('id'); $sth->finish; return $msgs; }I also observ that when there's no record in the resultset memory consumption is highter than when there's sontehing.
In Section
Seekers of Perl Wisdom
|
|