Anyone have any tips or directions for populating an XML document from a mySQL database?

Thanks.

To get the most performance, try to keep as much code as you can outside the DB... ie: Make multiple templates and then use php to populate the template with information obtained from the DB. Don't try to stick the entire page in the db, it'll only disappoint you.

Determine what it is you are storing, and how you plan to access it (ie: query types, search types) before you decide what form to store xml (text or blob or w.y.w).