I'm looking into enhancing an existing entry form on a Drupal 7 site. We currently are using a single content type and the field API to store all of the data. It already has 46 fields on it, but the business wants hundreds more.
I understand the limitations of MySQL only allowing 61 joins, so I assume that adding 100+ new fields to a single content type using the Field API is out of the question because MySQL will probably crash trying to load the content. (Prove me wrong if you know otherwise)
So my question is, should I create multiple content types which break out the form into a multi-step process, or is there some way to group data from multiple fields into a single table? (I'm thinking of field collections or something similar)
I feel like I have three options:
- Field API:
- Break out the fields across multiple content types
- Group multiple fields into a single table (field collections? field groups?)
- Form API:
- Implement custom fields and store the data in a custom table
- Contrib Module (such as Webform)
Using the form API and custom fields is not completely out of the question, but I'd like to be able to use the Field API if possible since the original form is already using it. I'm also not opposed to switching to webforms or some other method that is better suited for this purpose.