RE: retrieve many values
From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 02/22/05
- Next message: Walter Obermiller: "Re: [dbi] Re: Problem with DBD::ODBC (via unixODBC) connection to remote ADABAS-11 database"
- Previous message: Jones Robert Civ TTMS Keesler: "RE: retrieve many values"
- Maybe in reply to: Ing. Branislav Gerzo: "retrieve many values"
- Next in thread: Ing. Branislav Gerzo: "Re: retrieve many values"
- Reply: Ing. Branislav Gerzo: "Re: retrieve many values"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 22 Feb 2005 06:58:59 -0700 To: <2ge@2ge.us>, "DBI-Users" <dbi-users@perl.org>
Your code looks very suspect, see below.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: 2ge@2ge.us [mailto:2ge@2ge.us]
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.
- Next message: Walter Obermiller: "Re: [dbi] Re: Problem with DBD::ODBC (via unixODBC) connection to remote ADABAS-11 database"
- Previous message: Jones Robert Civ TTMS Keesler: "RE: retrieve many values"
- Maybe in reply to: Ing. Branislav Gerzo: "retrieve many values"
- Next in thread: Ing. Branislav Gerzo: "Re: retrieve many values"
- Reply: Ing. Branislav Gerzo: "Re: retrieve many values"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
