I’d like to know the limits on table column count and row size of the database? I’m asking because I think I hit the limit at 74 or so columns.
Thanks in advance!
There is no fixed number of columns, however, the total size of the allocated data per row is about 50k. When your table reaches more than 30 columns, it means it is time to rethink your design.
Having 74 columns in your table will result in substandard performance. It also means the data is not normmalized and should be refactored to break into multiple tables.