how many rows I can have in a database

Discussion in 'MySQL' started by Freewebspace, Apr 27, 2007.

0
  1. #1
    I have a table that has presently 69,000 rows and
    about 5 columns

    id, cname,url,description,sortid

    I want to just know whether a table can have more than 30 million rows

    and how many seconds it will take to execute this code


    whether I should have mutiple tables or I should persist with one table!
     
    Freewebspace, Apr 27, 2007 IP
  2. dcgamers

    dcgamers Peon

    Messages:
    38
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I would think it could but you need a really good server to do that and your website must be enormous! But I wouldn't do it. Queries must take forever...
     
    dcgamers, Apr 30, 2007 IP
  3. singh123

    singh123 Banned

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Do it freewebspace it will not take more that 60 mints.
     
    singh123, Apr 30, 2007 IP
  4. RaginBajin

    RaginBajin Peon

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4

    You can have your database as big as your want.. A query like that shouldn't very long at all. It will all depend on your indexes that you have setup.
     
    RaginBajin, Apr 30, 2007 IP
  5. Freewebspace

    Freewebspace Notable Member

    Messages:
    6,213
    Likes Received:
    370
    Best Answers:
    0
    Trophy Points:
    275
    #5
    Whether I can set up more than 1 index on a table
     
    Freewebspace, Apr 30, 2007 IP
  6. Kalyse

    Kalyse Peon

    Messages:
    1,221
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #6
    4294967295 is the magic number
     
    Kalyse, Apr 30, 2007 IP
  7. Freewebspace

    Freewebspace Notable Member

    Messages:
    6,213
    Likes Received:
    370
    Best Answers:
    0
    Trophy Points:
    275
    #7
    I am going to have just 90 million or less


    then what are the server specifications?
     
    Freewebspace, Apr 30, 2007 IP
  8. RaginBajin

    RaginBajin Peon

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Yes you can have more than one index on the table. There is a balance though of the amount of indexes you have on your table vs the speed of inserts into that table.

    A lot of times you will have to normalize your data a lot to ensure that you have very concise data. Another way is to use things such as merge tables or memory tables and break up your data into logical peices..

    If you have any questions please shoot me a PM. I do MySQL consulting/development along with VOIP consulting as a profession.
     
    RaginBajin, Apr 30, 2007 IP