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 a lot
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
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 hash
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
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
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 them
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,
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;
$data = undef;
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