#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    2
    Rep Power
    0
    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
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    1
    Rep Power
    0
    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...set_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]


IMN logo majestic logo threadwatch logo seochat tools logo