I am having trouble with Find Operation getting slower and slower each day. There are some design consideration as per some articles i have read recently which i will be doing as well.
I inherited this solution from another developer, Find is based on some Calculation fields which are based further on some other calculation fields (both calculation fields have 'Do not store results' option checked)
I know its not the best of designs, i wanted to ask for any possible improvement to Find process as its getting clumsy now.
I have indexed relevant fields, records are only around 2000 with approx 50 fields in the table.
Can PSOS be used in Find Operation?
Is there any other thing i must do at the beginning.