Your code looks very suspect, see below. -- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 2/22/2005 6:31 AM To: DBI-Users Cc: Subject: Re: retrieve many values Ing. Branislav Gerzo [IBG], on Tuesday, February 22, 2005 at 13:06 (+0100) wrote these comments: IBG> but it is good way ? It will not consume memory ? I'll try to be more exact: when I run this code: my $sth = $dbh->prepare_cached("select id, name from table"); my $sth = $dbh->$sth->execute(); [rr] This should read $sth->execute. Execute retruns a value, not a statement handle ($sth). it will eats all of my memory If I run this code: while ( my $ha = $dbh->selectrow_hashref("select id, url from table") ) { print Dumper($ha) } [rr] See above. it will eats all of my memory. -- ...m8s, cu l8r, Brano. [Bother! said Pooh discovering he was anatomically incorrect.] This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.