One Database As Oppose to 8 (Speed effected?)

Discussion in 'Databases' started by Al Capone, Sep 10, 2006.

0
  1. #1
    Well, it's starting to get hard for me to manage my websites and I am trying to clean up. One of my websites is using 8 Databases (one for every script) and I was wondering if I combind all those databases into one would it slow down my site? Any input would be great.
     
    Al Capone, Sep 10, 2006 IP
  2. ThomasNederman

    ThomasNederman Peon

    Messages:
    112
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I would say it would not slow down your database. Normaly it is the amount of querys used per page and the numer of joins in each query that determin the speed.(and number of users using the site at the same time)
     
    ThomasNederman, Sep 10, 2006 IP
  3. everypcneed

    everypcneed Peon

    Messages:
    238
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If traffic to your site in addition to the number of queries made to the database(s) is not overly high you will not see an affect on speed.

    One word of caution is to review the tables for each database to ensure there will not be duplicated tables for different databases which could cause issues in parsing the content for your site.

    Rick
     
    everypcneed, Sep 11, 2006 IP
  4. Al Capone

    Al Capone Well-Known Member

    Messages:
    784
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    140
    #4
    Great advice guys, thank you very much, you clarified this issue for me 100% :) rep points to both of you.
     
    Al Capone, Sep 11, 2006 IP