On Wed, 2008-04-30 at 02:32 +1000, Howard Lowndes wrote:
> I have a PHP script that inserts around 100K of records into a table on
> each time that it runs.
>
> 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?Are you doing this as one transaction or many? -Rob -- GPG key available at: <http://www.robertcollins.net/keys.txt>.
signature.asc
Description: This is a digitally signed message part
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
