On Wed, Apr 30, 2008 at 2:32 AM, Howard Lowndes <[EMAIL PROTECTED]> wrote:
> I have a PHP script that inserts around 100K of records into a table on
> each time that it runs.
maybe pastebin the relevant bits somewhere?
> It starts off at a good pace but gets progressively slower until it falls
> over complaining that it cannot allocate sufficient memory.
>
> I have increased the memory allocation in the script with:
> ini_set('max_execution_time', '3600');
> ini_set('memory_limit', '128M');
> but this only seems to delay the crash.
>
> I have also tried closing and reoprning the database` every 10K inserts,
> but that doesn't seem to speed things up either.
>
> Any other suggestions?
php4 or php5?
php5 has some nasty memory leaks with objects that reference each other:
http://bugs.php.net/bug.php?id=33595
if this applies to you, there are workarounds in the issue.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
