SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Enthusiast devhen's Avatar
    Join Date
    Jul 2002
    Location
    Salt Lake City, UT
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Storing site content in a mySQL database

    I have been told that storing my web content in a mySQL database and serving it from there would be an immense waste of resources. Is this true? Would the speed of my site be hurt by it? Would it eat up all of my server's resources if I had a lot of hits every day? My idea was to store content in a mySQL database and use PHP pages that would read their content from the dB. This would save me from having redundant data and the content would then be searchable within the dB. Is this a bad idea?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    I have been told that storing my web content in a mySQL database and serving it from there would be an immense waste of resources. Is this true? No. Would the speed of my site be hurt by it? No. Would it eat up all of my server's resources if I had a lot of hits every day? Perhaps more than static html, but generally speaking, no. My idea was to store content in a mySQL database and use PHP pages that would read their content from the dB. This would save me from having redundant data and the content would then be searchable within the dB. Is this a bad idea? No.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast devhen's Avatar
    Join Date
    Jul 2002
    Location
    Salt Lake City, UT
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks for clearing that up for me. i didn't believe it when i heard it but i'm new with mySQL and i wasn't sure. i'm going to go ahead with my original idea. thanks again


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
  •