LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   Export from MySQL to XML - question about memory (http://www.linuxquestions.org/questions/programming-9/export-from-mysql-to-xml-question-about-memory-4175430710/)

Stepo 10-05-2012 01:04 PM

Export from MySQL to XML - question about memory
 
Hi there!
I have small a problem. I've installed a tool for my shop - exporter for catalogue servers, where I can show my sortiment (you know Google shopping and others...). I have 1,5k items in DB, and when export tool beggins, it loads everything into array, then ram is full, when ram is full, caching starts - processor is on 99% and server drops.
I have an idea to do my own exporter, that will write the XML structure with echo into browser's window one product after another, without allocating much ram(I need to avoid of loading all in RAM) . Do you have some ideas, how to do it with the lowest hardware requirements?

Thank you for your advices!
Stepo

Snark1994 10-07-2012 11:52 AM

If you've solved the problem, posting the solution so that other people can benefit from the solution would be nice :)

Thanks,


All times are GMT -5. The time now is 01:56 PM.