Re: Row Limit?

On Mon, 26 Nov 2001, Tom Lane wrote:

> > I'm in the process of convincing a developer to not use MySQL for a web
> > based application.  While trolling around several sites I noticed the
> > 1600 attributes (columns) limit of PostgreSQL.  Now I can't even begin
> > to think of an application that would need that many I can see the MySQL
> > inclined comparing it to their 2945.
>
> Of course, the real bottom line is that if you think you need more than
> order-of-a-hundred columns, your database design probably needs revision
> anyway ;-)

I agree.  I've seen a few tens (ie. 20+) of column tables but they were
de-normalized because of performance issues and the distributed nature
of the database (Oracle).  (I think a couple of them were due to
laziness. :-)

Thanks for the clarification.


Cheers,
Rod
--
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler