SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Dec 2000
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there a limit to how many rows one MySQL table can contain.

    I think i saw somewhere that there was a limit of like 2 million or 20 million. At the time i took no notice because i thought i would never need to worry...now i do need to know...eeeeek.

    I had a quick look in the manual but couldnt find the information.

    Any ideas, information gratefuly recieved!..

    TIA
    Real men code with notepad...

  2. #2
    SitePoint Enthusiast
    Join Date
    Oct 2000
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    from mysql manual:
    ------------------------------------------------------
    Handles large databases. We are using MySQL with some databases that contain 50,000,000 records.
    ------------------------------------------------------
    it does not say limit but i think limit might be around that too.
    Great Dane
    Gokhan ARLI

  3. #3
    SitePoint Member
    Join Date
    Dec 2000
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hehe... ever tried to do a SELECT query on such a table? Especially with a WHERE clause? Man, you can be busy forever ... I already think it takes too long with 100k rows, imagine 50mil


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •