Performance of retrieving list.

2
Currently a have retrieve list with condition [CheckStatus='Checked'] [contains(IndividualSurName, $NameNotValidated)] which is quite slow>5 minutes. How to optimize this?
asked
1 answers
1

The next action was looping thru it and find probably equal persons.

Were talking about >10.000 records, Not that much, Solved it by

  1. Add an index on the field

  2. Change the condition to $name=$searchname

    Thanks

answered