Re: retrieve many values
From: Ing . Branislav Gerzo (konfera_at_2ge.us)
Date: 02/22/05
- Previous message: Walter Obermiller: "Re: [dbi] Re: Problem with DBD::ODBC (via unixODBC) connection to remote ADABAS-11 database"
- In reply to: Ing. Branislav Gerzo: "retrieve many values"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 22 Feb 2005 14:11:50 +0100 To: DBI-Users <dbi-users@perl.org>
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();
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) }
it will eats all of my memory.
-- ...m8s, cu l8r, Brano. [Bother! said Pooh discovering he was anatomically incorrect.]
- Previous message: Walter Obermiller: "Re: [dbi] Re: Problem with DBD::ODBC (via unixODBC) connection to remote ADABAS-11 database"
- In reply to: Ing. Branislav Gerzo: "retrieve many values"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
