Thread: Scalability

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Alameda, CA, USA
    Posts
    1
    Rep Power
    0
    I have a project where the master table will have 30-100,000 rows. Nightly batch for about 1/20th of the total row count. Light online traffic.

    Wondering if MySQL will scale this far. I have found a lot of performance numbers, but no indication of scalability.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    81
    Rep Power
    15
    The TCX guys boast about having DBs with millions of records, so you shouldn't find scalability at this level a problem.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Bergenfield, NJ, USA
    Posts
    2
    Rep Power
    0
    I've used MySql with a table that has 250,000 and, for a while at least, we were transfering the entire table nightly. We had problems, but NOT due to MySql. It sounds like MySql will scale just fine for your project.

Similar Threads

  1. Scalability and security
    By buddy__a in forum MySQL Help
    Replies: 7
    Last Post: November 11th, 2003, 03:36 AM
  2. Python Scalability
    By ragabash in forum Python Programming
    Replies: 4
    Last Post: September 3rd, 2003, 01:39 PM
  3. How good is php's scalability?
    By dynomike in forum PHP Development
    Replies: 16
    Last Post: June 27th, 2003, 07:45 PM
  4. Scalability again
    By dynomike in forum PHP Development
    Replies: 5
    Last Post: June 27th, 2003, 02:21 AM
  5. Scalability
    By Jason Gellings in forum MySQL Help
    Replies: 0
    Last Post: May 19th, 2000, 10:01 AM

IMN logo majestic logo threadwatch logo seochat tools logo