Plamen Stojanov <[EMAIL PROTECTED]> writes:
> I load 2Mb data from a database in perl hash and perl takes 15Mb
> memory. As I use this under mod_perl - perl never returns this
> memory to the OS. I must set a little number for MaxRequestsPerChild
> in order to restart perl interpreter not to eat
Hi there,
On Tue, 8 Oct 2002, Plamen Stojanov wrote:
> I have a ig mem usage problem with perl.
> I load 2Mb data from a database in perl hash and perl takes 15Mb memory.
This isn't a big memory problem unless you only have 32Mb RAM in which
case you're going to run out of memory with mod_perl
Rodney Broom wrote:
> From: Eric <[EMAIL PROTECTED]>
>
>
>>What about in the case of a big query result?
>
>
> I may have come into this thread a bit late, but can't you just undefine the storage
>when you're done with it?
>
> $data = $sth->fetchall_arrayref;
> #... do some stuff;
> $d
From: Eric <[EMAIL PROTECTED]>
> What about in the case of a big query result?
I may have come into this thread a bit late, but can't you just undefine the storage
when you're done with it?
$data = $sth->fetchall_arrayref;
#... do some stuff;
$data = undef;
---
Rodney Broom
President,
Eric wrote:
> What about in the case of a big query result? That is where it seems
> like you can get killed.
Riding a bike without a helmet will get you killed; big query results
are no problem. All you have to do is write your program so that it
pages through results rather than loading the
Hi,
What about in the case of a big query result? That is where it seems like
you can get killed.
I can see my processes grow very large in that case, and there is no way
the memory will come back. But I certainly don't want to limit my processes
because I might want to get a big result from a
Also, try to find an alternative to loading all that data into memory.
You could put it in a dbm file or use Cache::FileCache. If you really
have to have it in memory, load it during startup.pl so that it will be
shared between processes.
- Perrin
Anthony E. wrote:
> look into Apache::Resour
look into Apache::Resource or Apache::SizeLimit which
will allow you to set a maximum size for the apache
process.
both can be added to your startup.pl
--- Plamen Stojanov <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have a ig mem usage problem with perl.
> I load 2Mb data from a database in perl h
Hi all,
I have a ig mem usage problem with perl.
I load 2Mb data from a database in perl hash and perl takes 15Mb memory. As I
use this under mod_perl - perl never returns this memory to the OS. I must
set a little number for MaxRequestsPerChild in order to restart perl
interpreter not to eat
