将大型XML文件加载到mySQL数据库（PHP）

Question

For a new project I need to load big XML files (200MB+) to a mySQL database. There are +- 20 feeds i need to match with that (not all fields are the same).

Now when i want to catch the XML I get this error:

Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 171296569 bytes) in E:\UsbWebserver\Root\****\application\libraries\MY_xml.php on line 21

Is there an easy solution for this? It's not possible to get te feed in parts of a few MB's each.

Thank you very much!

P.s. has somebody an idea to match xml-feeds easy?

Answer 1

This should fix it:

ini_set('memory_limit', -1);