Can You Have Too Many tables

Discussion in 'MySQL' started by Justcars.ie, Nov 13, 2009.

0
  1. #1
    Just wondering if you can ever have too many tables in your database?? Im doing a huge project at the moment and hitting upon 20 tables.

    Cheers
     
    Justcars.ie, Nov 13, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    20 tables is nothing.. go ahead with it.
    MySql can handle many many more tables than 20.
     
    mastermunj, Nov 13, 2009 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    mwasif, Nov 13, 2009 IP
  4. marshalprince

    marshalprince Peon

    Messages:
    435
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    20 tables are not much for a big project. If it is well normalized then that is OK
     
    marshalprince, Nov 13, 2009 IP
  5. Justcars.ie

    Justcars.ie Peon

    Messages:
    46
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    cheers guys much appreciated
     
    Justcars.ie, Nov 13, 2009 IP
  6. noelite

    noelite Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I have use over 50 tables in one database, and some people use even more and have no issues. Feel no fear :D
     
    noelite, Nov 13, 2009 IP