Re: huge memory leaks.

> there is a reason for this, if i remember right it is a case of thinking that > you will use that much memory the next request so it just keeps all of it > allocated. it sort of makes sense to me but it chews extra ram and that is life. > on no production web server that has 10 people hitting it at once should it have > less than 512meg of ram. increase the memory AND use a decent database, pgsql or > mysql. benchmark each and you decide. I am already using postgres.. basically i have 3 databases (not 3 tables) and i need to join the results from them (havent found a way to do it internally in postgres.. if any1 knows please suggest) .. so i am doing it at PHP level.. its not really that slow.. (about half a second to sort 1000 records with a quicks sort written in php) its just that the memory grows to 20 mb per server (peak) and does NEVER come back to normal therefore killing the system. to me it doesnt make much sense to have 512 mb of memory (as you suggest) for a web site that has a DB with only 5000 records.. and receives.. which servers max 50 users per DAY . All i want is my memory back when its unused.. :) Giovanni Tummarello tummarel@ascu.unian.it Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email) at http://www.cauce.org/ and tell your Congresspeople how Spam mailings hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.