hi everybody,

i have a huge problem:

i have a big database (17 GB) and a query-script in perl. the machine on which the database is running has only 1 GB RAM. if i do a query via the perl script, the result set i get is always bigger than 1 GB and i get the error message:

>> out of memory

i have searched cpan for a modul with which i can tell perl not use the ram but the swap partition , but i didnt find anything

is there a way i can tell linux:
"if a running script causes a running out of memory, use the swap partition instead of the ram"?

thx for any help

I never get this message (out of memory), and I do alot of Graphics work, and the swap is used automagically when needed...................

How big is your swap partition??

As far as applications are concerned, there is no difference between ram and swap. It is all mapped to the same virtual addressing space.

Is your swap partition actually active? If you type:
free
does it include swap?

Else, do:

dd if=/dev/zero of=swap0 bs=1000000 count=1
makeswap swap0
swapon swap0

That will automatically start working in swap when memory nearly runs out.

--Abid Kazmi

Try reading through this article.

http://www.linuxjournal.com/article/8308

It tells you how to use more ram rather than hard disk and the other way around i.e more hard disk and less ram.