Hi guys,
I am parsing an XML file with PHP and inserting the rows in a MYSQL database.
I am using PHP simplexml_load_files to load the XML and a foreach to loop through the array and insert the rows into my database.
It works perfectly fine with small files i am testing, but it comes to reality I need to parse a large 500mb XML file and nothing happens.
I was wondering what was the right Php.ini config for this case ?
I have a VPS Linux Cent OS, with 256 mb of dedicated Memory and MYSQL 5.0.5. I have also set php memory_limit = 256M (maximum of my server)
Any suggestions, similar experiences will be greatly appreciated
Thanks