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

    Join Date
    Jul 2002
    Location
    Taos, New Mexico
    Posts
    4
    Rep Power
    0

    Question XML vs. MySQL for data extraction


    I'm going to be starting on a larger-sized project pulling data from several MySQL databases. And I'm just getting up to speed on XML and XSL. Is there really that significant a performance increase in pulling data from an XML file (using XSL and Sablotron) versus a direct connection to a database (using PHP)?

    I do want to make some of the data available to several other sites, and accessibilty for multiple devices will be an issue - so I'm leaning in the direction of XML. Nonetheless, I want to make sure it wouldn't be overkill - and create a possible performance issue...
  2. #2
  3. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    The speed issue it going to be largely determined by how you use the data. If you find yourself with an 8MB XML file that you only need 3 nodes from, I'm betting MySQL would give you faster access to that data.

    XML isn't really interchangeable with an RDBMS, but there are situations where it is as good or better. It all depends on your requirements, though.
  4. #3
  5. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    Taos, New Mexico
    Posts
    4
    Rep Power
    0
    thanks so much for replying. I've been struggling a bit with how the whole XML thing fits (or could fit) into my future projects. And since we do quite a bit of database development, I wasn't sure if I should just stick with what we've got...
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Location
    San Jose, CA
    Posts
    58
    Rep Power
    15

    XML Tip


    The power of XML is not in hand coding the XML documents and selecting node values with XSL.

    A XML "file" is usually created from a database, cached and then available for smaller queries. You never would want to have a XML file that is too large because it will be a resource hog.

    XML is Extensible but not all that fast yet.... Good luck.
    Thank you,

    Paul B Hepworth

    Questions & Answers http://www.lds.org
  8. #5
  9. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    Taos, New Mexico
    Posts
    4
    Rep Power
    0
    Thanks Paulblo - I was thinking that might be the way to go (db to XML file). Then whenever anyone made changes to the databases, new xml files would be created to replace to previous ones...

    Sorry for the delay on this - on vacation last week.

IMN logo majestic logo threadwatch logo seochat tools logo