I have noticed that each custom field takes up 2 columns in the channel data table.
- The second column often seems to have little value.
- Existing columns do not seem to be recycled for new channel field groups with the same field type.
This seems like quite a wasteful design because:
- It increases the size of rows in other channels.
- Must surely come with various performance penalties (like full-text search perhaps).
Are there ways to optimize this? am I worrying unduly? what is the realistic maximum number of custom fields for an ExpressionEngine site?