I work with an EE website that has 293 custom fields, and 125k entries. Nowadays, whenever I am adding a new channel field, it takes between 4 and 5 minutes to complete the task! Also, it can take up to 2 minutes to delete a channel field.
I understand that this task requires adding a row to the exp_channel_fields table, as well as adding at least 2 columns to the exp_channel_data table.
Anybuddy have any insight into why this is taking so long? Any tricks to speed this up?
- EE 2.5.5