Number of columns in table

Hi Pavan,

There will be no issues with having the custom fields in Sugar.

An admin user can create as many custom fields as they want using Studio in Sugar.

But please follow some best practices like limiting the max length of text fields as per the field data. By Default max size of the text field is 255. But you can reduce based on the field data you are storing. This is good to follow because if you are using Mysql. it has maximum row size limit.

Hope this information is helpful :)

Thanks,

Poojitha K

Hi,

That's true, and you have another limit of 255 column in MySQL table. That's mean that you can have only max 250 custom fields by module, but as Francesca Shiekh said, if it happend, challenge the business team ;)

isn't the 'theoretical limit' 4,096 columns, as long as the row size limit isn't exceeded?
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html 

Would be great if somehow we could see the current row size for each module within Studio

isn't the 'theoretical limit' 4,096 columns, as long as the row size limit isn't exceeded?
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html 

Would be great if somehow we could see the current row size for each module within Studio