0

I'm converting a console app into a WCF service and have hit a minor snag.

since there are more than 2500+ records to process and for each record I need to ensure the user initials in the list, loading the user through ensure user and the executing the query each time will definitely take a long time .

Is there a workaround to this?

Improve this question
2
  • Are users are different in each list. – Aanchal May 19 '14 at 5:31
  • yes, each list item corresponds to a user – Aman Gupta May 19 '14 at 5:32
0

You can first query the list with distinct users in the list and create/ensure that users.

So you don't need to query for every listitem.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.