One MYSQL database over many sites?

Discussion in 'Programming' started by Tom_e_rock, Aug 24, 2006.

0
  1. #1
    When setting up a site, I find all getting into the host, setting up a database, and all that a drag.

    Instead of using each hosts database, would it be smart to to just connect to one host's database and use the tables on there.. Or would this cause a slow server?
     
    Tom_e_rock, Aug 24, 2006 IP
  2. drewbe121212

    drewbe121212 Well-Known Member

    Messages:
    733
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    125
    #2
    It just depends on what data is being submitted and being retrieved from the database. As long asyou aren't planning on hosting terabytes of accounts on 1 database and pulling it from multiple sites, it should be alright. Just remember, doing this is now eating up bandwidth as the server has to go out of itself to find data rather then staying at "home".
     
    drewbe121212, Aug 25, 2006 IP
  3. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I host all my sites on one host and use the same database for each site.
     
    mad4, Aug 25, 2006 IP
  4. Tom_e_rock

    Tom_e_rock Peon

    Messages:
    428
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Lets say the database had 500 tables, with 50,000 rows.. wouild this be slow?
     
    Tom_e_rock, Aug 25, 2006 IP
  5. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #5
    If 500 tables were required... then so be it but theirs a fine line between "Normalizing" tables and Over-Normalizing. Regarding speed though 50,000 rows should be no problem, (if they are indexed, with a pk, and integer datatype on the id field)
     
    ccoonen, Aug 25, 2006 IP