SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    Jan 2005
    Location
    Hiding from the world
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    relational vs single big table

    Hi,
    sorry if this has been asked before but i am trying to decide how to build our new website (updating from our current one). The point of the website is to return data rather than just pages.

    So basically the staff member who puts the information together uses an excel spreadsheet with all of the information in separate rows.

    The website currently has numerous tables that all link together, so an update requires the table splitting into the relevant tables.

    I'm just evaluating various options and i am wondering what the impact would be to simply have a single mysql table containing all of the info.

    We have about 600 records and i don't see that rising in the near future and even if it did it wouldn't top more than a couple of thousand records.

    would i see a noticeable impact on website speed? cpu useage? etc using a single table

    any opinions appreciated

    thanks
    If i am a product of your imagination you should try harder!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Noppy View Post
    ... i am wondering what the impact would be to simply have a single mysql table containing all of the info.
    it would make things a lot easier for you,

    Quote Originally Posted by Noppy View Post
    would i see a noticeable impact on website speed? cpu useage? etc using a single table
    probably not
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jan 2005
    Location
    Hiding from the world
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply. Pretty much what i was hoping you'd say

    Obviously not against a full relational setup but it really didn't seem to make that much sense in this instance.

    Thanks
    If i am a product of your imagination you should try harder!


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
  •