Re: Memory Leaks

Are you freeing results as you go? You might try making a counter and issue a free_results (I'm working w/ MySQL and the command is mysql_free_results ($sql_results) where $sql_results is the holder for the query.) command after every 5000 records are transferred. Ed "Cameron Just" <C.Just@phoenixdigital.com> wrote in message news:4.3.2.7.0.20001004132625.00b6d100@sonitus.ulypea.com.au... > Hi, > > I have written a php script which will transfer the contents of one table across to another database. > It does a few data integrity checks during the transfer as the new (cleaner) table structure contains lookup tables instead of text fields. > > The script needs to import approx 1 million records but gradually grows in size until the server crashes. > > I can only seem to process 10,000 records at one time. > Is there anyway I can stop the script from slowly chewing up all the memory? > Are there any housecleaning routines I can run to free up memory? > > > **************************************************************** > Cameron Just (C.Just@phoenixdigital.com) > > Phoenix Digital Development > **************************************************************** > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >