How many rows in DB

Discussion in 'Databases' started by desperateboy, Mar 16, 2010.

0
  1. #1
    Hi,

    How many rows we can add in sql database. Is there any limit or unlimited.
     
    desperateboy, Mar 16, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    In most they are limited to a very high number. You will run into performance constraints far earlier than reaching any set limit on the number of records in a database. Your limit in just about every case is the hardware that the database is running on, and the actual design of the database and the application accessing it.
     
    Last edited: Mar 16, 2010
    jestep, Mar 16, 2010 IP
  3. vntutor

    vntutor Peon

    Messages:
    1,721
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #3
    There is no maximum number of records in a table.
     
    vntutor, Mar 16, 2010 IP
  4. niroshana35

    niroshana35 Well-Known Member

    Messages:
    316
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    138
    #4
    They are right there is no limit. Currently I have website that uses a sql database with 1,085,623 rows.
     
    niroshana35, Mar 16, 2010 IP
  5. umar_alatas

    umar_alatas Active Member

    Messages:
    116
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #5
    For record in SQL Server is growth follow your insertion record, it no have limit. Currently on 4 million record make the processing more slow than below that number.
     
    umar_alatas, Mar 16, 2010 IP
  6. jakkevin4v

    jakkevin4v Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    36000
    rows in a Table
     
    jakkevin4v, Mar 18, 2010 IP
  7. killaklown

    killaklown Well-Known Member

    Messages:
    2,666
    Likes Received:
    87
    Best Answers:
    0
    Trophy Points:
    165
    #7
    uh.. you can have more then 36000 considering i have 4.2 million in one table currently.
     
    killaklown, Mar 20, 2010 IP