Validation performance

Right, I am supporting da database that was created sometime ago.I’ve managed to get rid of some other issues I was having and posted on here some time ago (Re-assigning image colours).

My next question is to do with - the users have reported performance problems when tabbing between the different fields on the documents.

I can re-create this to a certain extent in dev, e.g. its not as ‘instant’ as I was hoping, an egg timer appears when you click in each field. It does seem slower than other databases for example.

The only thing I can think of that is causing it is validation formulas.

For instance a lot of fields have for instance:

@If(Priority=“”;“Please enter the priority asking for this change”;@Success)

In the ‘Input validation’ section. Is this an acceptable formula? I guess I could move all the validation to QuerySave LS event, but then it’s not as ‘instant’, e.g. have to wait to save to get the validation…?

Subject: refresh fields?

Check the form properties, see if automatically refresh fields is checked

If it is then any computed fields or input translations formulas will be recalculated each time someone tabs, so check these as well to see what’s going on

The validation formula you posted shouldn’t be a problem