Nolock & Distinct for Query Expression

Hi All,

We have faced an issue that Retrieve and Retrieve Multiple (Query Expression) plugins fetching record too slow when there are more concurrent user access the system , so we have used nolock to overcome.


QueryExpression queryExp = new QueryExpression("account");
queryExp.Nolock = true;
queryExp.EntityName = "account";
var cols = new ColumnSet(new[] { "name", "accountid" });
queryExp.ColumnSet = cols;
queryExp.Distinct = false;
var accounts = service.RetrieveMultiple(queryExp);