Helpful Information
 
 
Category: Programming Languages More
XML XSLT and MySQL

For you guys who have eben out there working with XML.

I have a relational DB built in MySQL that needs to go XML.

Here is an example. I have an article, with things like title, abstract, and body. How do I store this? As a single XML DOC in the DB, or as 3 cols in the DB.

What I am curious about are the pros and cons. Like which way is faster? (including server side XSL parsing), and is there any real benifit to making it one DOC, or visa versa?

-G

i did the same thing. i pulled data off a MYSQL table, created a valid xml document
with a servlet. i used the IBM parser. it works: http://www.jspsquad.damud.com/search/data/frameset_to_db.html
i first pulled the table data into a string, just for show, then wrote the parsed xml to: http://www.jspsquad.damud.com/template/jox/trial.xml

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by SimonWaltr:
For you guys who have eben out there working with XML.

I have a relational DB built in MySQL that needs to go XML.

Here is an example. I have an article, with things like title, abstract, and body. How do I store this? As a single XML DOC in the DB, or as 3 cols in the DB.

What I am curious about are the pros and cons. Like which way is faster? (including server side XSL parsing), and is there any real benifit to making it one DOC, or visa versa?

-G[/quote]