Export from MySQL to XML - question about memory
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!
Last edited by Stepo; 10-05-2012 at 12:06 PM.