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?
--
Howard
LANNet Computing Associates <http://lannet.com.au>
When you want a computer system that works, just choose Linux;
When you want a computer system that works, just, choose Microsoft.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
