On 30/04/2008, at 2:32 AM, 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 also tried closing and reoprning the database` every 10K
inserts,
but that doesn't seem to speed things up either.
Any other suggestions?
How are you inserting the data? What library?
It might be that you need to free or flush the handle.
Michael Chesterton
http://chesterton.id.au/blog/
http://barrang.com.au/
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
