"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?
regards, tom lane