SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Jan 2004
    Location
    Wheelersburg
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How much can mysql handle

    Hey guys,

    I am making a database for a baseball league, and entry wise there will be around 1000 teams, with 20 players each and about 19 columns for each player..So around 20,000 rows of information with 19 columns filled for each row..

    can mysql handle such a load..and if so, how much more could it handle?
    http://chaseschwalbach.com

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,340
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    20,000 rows is small

    20,000,000 rows is medium

    20,000,000,000 rows is large

    mysql can handle large tables

    for more info, visit http://www.mysql.com/it-resources/case-studies/
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2004
    Location
    Wheelersburg
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks
    http://chaseschwalbach.com


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
  •