Author Topic: Custom Fields - Limitation? (Read 1054 times)

kathykelley · October 21, 2008, 08:54:11 am

I have been reading and am confused as to if there is a limitation on the number of custom fields that can be created in the most current version of civicrm. It looks like for older versions there was a limit of about 30 (20 to be safe). Current articles say it is unlimited. Could someone please provide me with the correct answer?

I have a client that has over 100 fields (coming from Kintera) that they would like to move over.

Thank you for your help.

Donald Lobo · October 21, 2008, 10:24:12 am

We will fix the documentation today and clean that section up today. Custom groups/fields are backed by mysql tables, so they have the same advantages/limitations of mysql tables. You'll need to think about db design and schema as you plan custom groups/fields. For example in the below case splitting the fields into 5 to 10 groups of 10 to 20 fields in each group seems a reasonable choice. Having too many groups (> 40?) you might run into mysql LEFT JOIN limiations. Having too many fields in one group, you might run into mysql max row size limitations

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Custom Fields - Limitation? (Read 1054 times)

kathykelley

Custom Fields - Limitation?

Donald Lobo

Re: Custom Fields - Limitation?