Does it matter if i have one or two

Discussion in 'MySQL' started by hitboy, Jul 27, 2007.

0
  1. #1
    I was wondering for one of my sites I have one database for it but the catch is there are about 5 different scripts running on the same database... does it matter i keep them all on the same database or should i move them to each separate databases...

    I am talking about mysql..
     
    hitboy, Jul 27, 2007 IP
  2. logylaps

    logylaps Active Member

    Messages:
    761
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    85
    #2
    I believe its better to give one database per site... keeps things neat when you get lots of sites...
     
    logylaps, Jul 27, 2007 IP
  3. hitboy

    hitboy Well-Known Member

    Messages:
    2,939
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    170
    #3
    im more referring to the quires etc on the database if its good or bad if its a lot of quires on the same database..
     
    hitboy, Jul 27, 2007 IP
  4. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #4
    I would have different ones.

    Some hosts limit the number of connections at the same time.
     
    Colbyt, Jul 28, 2007 IP
  5. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #5
    Depends on what things you do on that DB. give me more info.
     
    gibex, Jul 28, 2007 IP
  6. no-username

    no-username Banned

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If your one site have Insertion & Modification query and rest of sites have read only, then ok. Other wise you must have one script one database to avoid redundancy.
     
    no-username, Jul 30, 2007 IP
  7. hitboy

    hitboy Well-Known Member

    Messages:
    2,939
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    170
    #7
    ok thanks for the great info guys..
     
    hitboy, Jul 30, 2007 IP