Are there any performance issues to consider when designating Salesforce custom object fields as constraints vs. triggers (via the 'Edit Visible Fields' selector), or is the decision only based on the intended use of the field?
Generally, people make both available and choose to use them as appropriate. I don't think there would be a large performance impact unless you are using them very unwisely with a custom object that has a ridiculous volume.