SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Dec 2004
    Location
    At My Desk!!
    Posts
    1,642
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database and XML Speed Tests

    Hi All,

    I was wondering if anyone has done any work on checking the speed of database queries over parsing XML. I would normally write a website that uses a database and nothing else but a recent project I have been working on means I am using an XML file to generate the site menu and another one for the stock items.

    Everything is working really fast but it leaves me wondering if it would be faster using a database or not.

    As far as amount of data goes, there isn't much to the XML files really and when the user has selected a menu option, it's just the case of finding that in the XML and looping through it's children to display the information.

    Any thoughts?
    "Am I the only one doing ASP.NET in Delphi(Pascal)?"

  2. #2
    SitePοint Troll disgracian's Avatar
    Join Date
    Aug 2006
    Location
    Samsara
    Posts
    451
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    For small datasets (and a menu for a UI is never going to get big enough to qualify as "large" in computing terms) it doesn't really matter. Even if one approach is 100 times faster than another, the difference is still likely to be measured in milliseconds.

    Until there are noticable performance issues, the best approach is the on that is easiest to implement and maintain.

    Cheers,
    D.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •