Re: Reading from XML file

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.