Re:How NoSQL forced the evolution of a scalable relational d...
by matwood on Friday July 13, 2018 @10:02AM
(#17523036)
There may be other limitations, but MSSQL supports[1]:
Columns per nonwide table 1,024
Columns per wide table 30,000
I think a lot of this RDBMs can't do X, came from using a MySQL. It has improved some, but was garbage until recently.
I'm not sure how wide you're taking about, but PG support up to 1600 depending on the datatypes (there is a page size maximum). Oracle supports 1000 IIRC.
I think a lot of this RDBMs can't do X, came from using a MySQL. It has improved some, but was garbage until recently.
I'm not sure how wide you're taking about, but PG support up to 1600 depending on the datatypes (there is a page size maximum). Oracle supports 1000 IIRC.
[1] https://docs.microsoft.com/en-us/sql/sql-server/maximum-capa...