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