Scalability - Dev Shed

Dev Shed Forums Sponsor:

August 24th, 2000, 12:38 AM

guysiliconstratcom

Junior Member

Join Date: Aug 2000

Location: Alameda, CA, USA

Posts: 1

Time spent in forums: < 1 sec
Reputation 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.

August 24th, 2000, 06:45 AM

christucker2

Contributing User

Join Date: Aug 2000

Posts: 81

Time spent in forums: < 1 sec
Reputation Power: 14

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

jtomberg

Junior Member

Join Date: Aug 2000

Location: Bergenfield, NJ, USA

Posts: 2

Time spent in forums: < 1 sec
Reputation 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.

Viewing: Dev Shed Forums > Databases > MySQL Help > Scalability

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump