August 24th, 2000, 12:38 AM
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.
August 24th, 2000, 06:45 AM
The TCX guys boast about having DBs with millions of records, so you shouldn't find scalability at this level a problem.
August 24th, 2000, 10:40 AM
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.