Cross posting here, since this is primarily a TNEW issue, but I'm keeping the poll in one place (under IT and Admin):
Poll: How heavily do you use LTR_TNEW_CUSTOM_FORM_DATA?
So, I'm gearing up to use a lot more Contribution Types (LTR_TNEW_CONTRIB_TYPE) in our consortium, and as I've been testing this out in Test and Dev it seems to be having dire performance consequences. While it is a lot of Contribution Types (I guess), it doesn't feel like it would be a lot for a larger consortium. LTR_TNEW_CUSTOM_FORM_DATA is the table that really explodes when you add additional Contribution Types, and presumably the main one referenced by "Reset Custom Forms". What I observe is that the Reset Custom Forms and Reset Cache buttons became slow, then frequently timed out. I'm seeing worse behavior in our Dev environment, which has fewer forms than Test, but is also probably resourced less and also is in v16, while we are still in v15 for Live and Test.