RE: [PHP] huge memory usage in PHP 4.0.2 object programming?

Hi Teodor, Thanks for your reply! After the post we do tried: - add the free result to database query routines - change mysql pconnect to plain connect Still the same result. :( Vincent -----Original Message----- From: Teodor Cimpoesu [mailto:teo@digiro.net] Sent: Saturday, September 16, 2000 9:35 PM To: vincent@aib.net Cc: php-general@lists.php.net Subject: Re: [PHP] huge memory usage in PHP 4.0.2 object programming? Hi vincent! On Sat, 16 Sep 2000, vincent@aib.net wrote: > Hello, > > I'm writting a program using PHP4's object feature. However after each run I found that the apache process hold up > 70M of the memory!!! In the 2nd run however it doesn't make the apache process grow to 140M, remain 70M. > > The program read 2000 records into 2000 objects from a mysql database and do some processing to produce another > 2000 objects for later use (It hasn't finish). Is PHP4 will not release memory for objects, or rather this is an apache problem? > I add unset() to the final produced objects seems still doens't free up the memory after the run. > > do use make use of mysql_free_result() in your script? maybe mysql resultsets eat up memory. 2c -- teodor