Re: retrieve many values

2ge_at_2ge.us
Date: 02/22/05 

Date: Tue, 22 Feb 2005 14:31:40 +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.]

Relevant Pages

  • javascript animation eating all memory
    ... I have this bit if javascript and it animates an image well, ... problem is that the more it runs the more memory it eats on the client ... Can anyone help me make this not eat all avaliable memory, ... // The following script implements rotating and fading the merchant ...
    (comp.lang.javascript)
  • Re: Memory full-problem
    ... What do you mean "eats" all of your memory - how are you determining this? ... How much RAM does your Mac have? ... Also after the update Word often eats ...
    (microsoft.public.mac.office.word)
  • [AMD64] X.org build eats all the memory when compiled with GCC 4.2
    ... I recompiled X.org yesterday and hit the following problem ... or -O option it eats all available memory and then gets killed by the ... t +37493 419763 (mob) ...
    (freebsd-current)
  • [AMD64] X.org build eats all the memory when compiled with GCC 4.2
    ... I recompiled X.org yesterday and hit the following problem ... or -O option it eats all available memory and then gets killed by the system. ... t +37493 419763 (mob) ...
    (freebsd-current)
  • Re: Can a process be made immune to out-of-swap-space kills?
    ... On 10/30/05, Doug Lee wrote: ... I accidentally run something that eats up too much memory ... > and causes the pager to run out of swap space and start shooting down ...
    (freebsd-questions)