Re: Memory leak!!

On Wednesday 09 April 2003 06:58, Tom Lane wrote:
> "P.N.Guru Prasad" <pnguruji(at)yahoo(dot)com> writes:
> > while (1) {
> > print "sql executed and returned :", $Dbh->prepare("select user_id from
> > users limit 1")->execute, "\n";
> > }
>
> I'm not a DBI user, but I'd kinda expect that executing a query would
> result in an object holding the results from that query. Don't you need
> to do something to close/delete the result objects you're generating?

Does

while (1) {
my $sth = $Dbh->prepare("select user_id from users limit 1");
print "sql executed and returned :", $sth->execute, "\n";
$sth->finish();
}

make any difference?

If not try asking the dbi-users list, dbi-users(at)perl(dot)org
( http://lists.perl.org/showlist.cgi?name=dbi-users )

Ian Barwick
barwick(at)gmx(dot)net