MySql Capacity

Discussion in 'MySQL' started by MoveForward, Jan 12, 2007.

0
  1. #1
    Hi. Quite new to MySql and have a query in relation to a site I want to move from Sql Server.

    Can MySql handle a product database of around 200,000 rows in one table?

    Thanks for any advice
     
    MoveForward, Jan 12, 2007 IP
  2. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yes, easily.
     
    mad4, Jan 12, 2007 IP
  3. just-4-teens

    just-4-teens Peon

    Messages:
    3,967
    Likes Received:
    168
    Best Answers:
    0
    Trophy Points:
    0
    #3
    i dont think mysql has a limit, the question would be can your server handle a database with 200,000 rows in?
     
    just-4-teens, Jan 12, 2007 IP
  4. MoveForward

    MoveForward Active Member

    Messages:
    201
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Thanks. Do you mean disk space wise? Or are there other performance issues associated with a database of this size? The site will probably get around 2000 uniques a day and I imagine you have a max of 5-10 concurrent users accessing this large table.

    (btw: can anyone recommend a good php/mysql developer that can knock up a template page and construct this database for me from sql server?)

    Thanks.
     
    MoveForward, Jan 12, 2007 IP
  5. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #5
    mad4, Jan 12, 2007 IP
  6. MoveForward

    MoveForward Active Member

    Messages:
    201
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #6
    Thanks, I will check them out. Can you recommend any developers?
     
    MoveForward, Jan 12, 2007 IP