Ago wrote:
I have a PHP script who reads data from a XML file uploaded via http form.
This file is about 15 MB. The script builds a query of thousands inserts as
many as the products the XML file contains (more or less 40000 inserts).
After 4 minutes the httpd process aborts by itself. What can it depend on? I
have also increased the memory_limit parameter in php.ini to 32 MB and
set_time_limit to 0. What can I do anymore?
Use a single insert statement instead of 40,000 - or - Drop the primary key before the insert and recreate it after wards. - or - save data into a csv file and use 'load data in file'
Having said that the page shouldn't stop loading after 4 minutes if you use set_time_limit please see if you have some other setting that may be killing it.
Thanks.
-- Raditha Dissanayake. --------------------------------------------- http://www.raditha.com/megaupload/upload.php Sneak past the PHP file upload limits.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
