[wplug] Comparing database size (was Re: Large Database)

[Bill Moran]

In response to kabel <lists at voidship.net>:

> Bill Moran wrote:
> > In response to George Larson <george.g.larson at gmail.com>:
> >
> >> I don't mean to 'jack the thread but would you mind to clarify why you chose
> >> PostgreSQL over MySQL?  We use MySql at work, so I'm just curious....
> >
> > Do you have over 100,000,000 rows in any table?
> >
> > It's been a while since I abandoned MySQL for various reasons, but a few
> > years ago, putting over 100,000,000 rows in a MySQL database would basically
> > kill the thing.  Granted, the MySQL programmers are constantly improving,
> > and there have been many releases, so that performance issue may be gone.
> 
> FWIW, I have a MySQL table with 183,286,107 and it's constantly growing 
> and being queried.  I have another one of similar size that is equally 
> as solid.   I haven't noticed any major performance issues.

Looks like my information is outdated then.

Out of curiosity, anyone running a MySQL database with more than a
billion rows?

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/