Msg#: 3491792 posted 7:57 pm on Oct 30, 2007 (gmt 0)
Hello, thanks for all your support and help! This might sound stupid, but I am having trouble opening a 712MB XML file from Amazon.com. This is the smallest version that they offer and when I run my PHP script on a smaller file (25MB) it opens fine. By the way I'm using the SimpleXML function built into PHP 5. Yet when I try to open the larger file through the PHP script I get error messages after about 3-5 minutes about allocated memory and SimpleXML being unable to parse.
I just recently upgraded my computer's RAM to 1.25 GB but it doesn't seem to fix the problem (but did seem to help somewhat). I have no background programs running except the basics and Apache & MySQL too. Yet, it still won't open. I don't really have much money to upgrade my computer anymore at the moment. Is there anything that anyone could recommend to help? Thanks!
Keep coding! Peace!
[edited by: CWebguy at 8:01 pm (utc) on Oct. 30, 2007]
Msg#: 3491792 posted 10:24 pm on Oct 30, 2007 (gmt 0)
In the PHP.ini file the memory limit was set to 128MB, but that can't be right because whenever I run the script it uses the entire system's memory. Not only can I hear my computer chugging hard (kind of scary) but the memory availabe drops into the single digits :( . I tried upping the memory_limit to 700MB in the .ini file and restarted Apache but got same warning messages and results:
and a couple others. But like I said, it will do the smaller file which is in the same format so the script is not the problem. Is there anything else that can be done? Maybe a function in PHP or another setting that would work to open this large XML file and parse it?
Msg#: 3491792 posted 10:29 pm on Nov 1, 2007 (gmt 0)
well if your record is
and you've split the data then theres a possibility that
will become <email>fred@
then in the next file fred.com</email>
Which is fine if you're going to join the two back together again, but with a 700mb file you're far better to deal with each individual file and whack it in a database rather than rebuild the xml file and try and work with that.