WEB have there been any studies on the efficiency difference between a database and files

Discussion in 'OT Technology' started by White Stormy, Apr 25, 2009.

  1. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,489
    Likes Received:
    70
    Location:
    Sparkopolis
    on a web server?

    like if I have a thousand 500 word articles.. would injecting database cells into a page upon request be quicker/better than requiring each user to link to another [xml] file on every request? I assume there would be pros/cons for each, and I'd be curious to read them
     
  2. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
  3. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,489
    Likes Received:
    70
    Location:
    Sparkopolis
    that's what I figured.
     
  4. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    I'm a fan of having that kind of content in the database. Especially if you have the need to search/index said content. Let the db do what it's meant to do.
     
  5. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,924
    Likes Received:
    11
    Location:
    Los Angeles
    :werd:
     
  6. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,489
    Likes Received:
    70
    Location:
    Sparkopolis
    yeah and I know most people would feel that way.. but I was wondering if there are numbers to back it up

    for a site that might only update once a month (or for lots of small company web sites that might only update once a year), the xml approach might be better just because they wouldn't need a dedicated web person to change stuff. just give them a blank xml template and have them fill that out and upload it. more versatile than static pages, and if they want to change style, they don't have to mess with content. and avoid the overhead of having a database for a site of 10 pages

    etc
     
  7. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
    it really comes down to your application...if you know the site is 10 pages, it might make sense ot use a flat file system. that's your call as a developer though.
     
  8. White Stormy

    White Stormy Take that, subspace!

    Joined:
    Sep 17, 2002
    Messages:
    85,489
    Likes Received:
    70
    Location:
    Sparkopolis
    yeah and as a developer I probably would use xml instead of database for those situations.. unless it uses ten times as much cpu and takes twice as long to send out, etc ;)

    that's why I'm lookin for any kind of real numbers on speed differences or cpu usage, etc
     
  9. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
    with 10 pages (or whatever) it's going to be negligible against any cpu
     

Share This Page