SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    table recommended size limit (rows)

    Hi mates,

    Say, what is the recommended size for tables in MySql, from the numbers of rows point of view. To be more specific, after how many rows should I consider spliting the table: 100,000? 500,000? Is there a limit at all?
    Compare Hundreds of Web Hosting Plans

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Several million rows is fine if you have your table indexed properly for any columns you are searching on specifically or joining on with another table.

  3. #3
    SitePoint Guru kgtrip's Avatar
    Join Date
    Jun 2003
    Location
    Karplakistan
    Posts
    804
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok thanks
    Compare Hundreds of Web Hosting Plans


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
  •