Re: Reading from XML file

It is not a database problem, it seems to me something about the reading of the XML file. This is my code about this: $data = implode(file("example.xml"), ""); xml_parse_into_struct($parser, $data, &$structure, &$index); xml_parser_free($parser); it could be the array $data creation fails because the example.xml is too big, infact if I decrease the size of xml file the script works (even if it lasts several minutes), unfortunately the xml_parse_into_struct function needs the $data array as argument. My PHP version is 4.0.6. "Raditha Dissanayake" <jabber@raditha.com> ha scritto nel messaggio news:40B34A3A.2060208@raditha.com... > 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.