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

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

Thanks,