[wplug] Large Database

[kabel]

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.

kabel