Question about module custom fields limit

Hi,

I have the module accounts with around 70 custom fields. I see the accounts_cstm table has all the 70 columns. My question is, Sugar has a limit to create new custom fields? Sugar creates another cstm table where it arrives to certain number of columns? Because i think that have a table with, for example, 200 columns, it has a performance impact in the database no?

thanks.

  • Hi Diego Celdrán,

    The application does not impose a limit, nor does it create an additional table when the _cstm table gets too large.

    The limits to keep in mind are the technology limitations.

    See this.

    "The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, even if the storage engine is capable of supporting larger rows."

    More fields can be added to a custom table if Max Size of textfields is kept low in each field and if the fields added are of particular types that do not reserve significant space on the table when empty.

    Hope this helps!