I have a content type that has about 80 fields.
It has a select list field at top and there are two options:
If Yes is selected all the 80 fields are used and if the No is selected, the last 30 fields are not used. For both two options, 50 fields are common.
I wonder, if I should go for creating two content types for this structure, or if continuing with "one" (only) is better. If I continue with this "one" content type, 30 fields will be empty for the "No" options and can it be a "bad" thing for the database (waste of space etc.)?
(If I continue with one content type I will use some modules such as Conditional Fields etc).
Is there anybody faced with a similar situation and is there a "better" way?
(Additional information: this content type is used for an academic resource. If the resource is in English I will only fill the 50 fields. If the resource is in another language I will fill the 50 fields and also fill the other 30 fields.)