Is there a maximum # of tables allowed in MySQL?

Discussion in 'MySQL' started by stupidfly, Feb 16, 2007.

0
  1. #1
    Is there a maximum number of tables allowed in MySQL? I am making a new site and right now, I think I'm going to need 100+ tables.
     
    stupidfly, Feb 16, 2007 IP
  2. norfstar

    norfstar Peon

    Messages:
    1,154
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    0
    #2
    MySQL databases don't have a set upper limit on number of tables. With very very high numbers of tables, there might be a negative effect on performance, but when you're talking about numbers in the hundreds you should be fine :).
     
    norfstar, Feb 16, 2007 IP
    stupidfly likes this.
  3. stupidfly

    stupidfly Peon

    Messages:
    129
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Great! Thanks.
     
    stupidfly, Feb 16, 2007 IP
  4. toby

    toby Notable Member

    Messages:
    6,923
    Likes Received:
    269
    Best Answers:
    0
    Trophy Points:
    285
    #4
    no problem with having more tables, but do make sure you have enough web space to accommodate those tables. Otherwise, you are fine!
     
    toby, Feb 16, 2007 IP