camlex icon indicating copy to clipboard operation
camlex copied to clipboard
verified publisher icon sadomovalex

WhereAny is slow

Open sadomovalex opened this issue 8 years ago • 0 comments

Pavel_Kudishin[CodePlex]
Following method is very slow: IQuery query = Camlex.Query().WhereAny(expressions);

where IEnumerableltExpressionltFuncltSPListItem, boolgtgtgt expressions = claimIds.Selectltint, ExpressionltFuncltSPListItem, boolgtgtgt(claimId =gt (x =gt ((int)x[quotIDquot] == claimId)));

int[] claimIds - array of any integers.

If claimIds.Length==20, then WhereAny takes 10 seconds. If claimIds.Length==15, then WhereAny takes 4 seconds. If claimIds.Length==10, then WhereAny takes 2 seconds.

sadomovalex avatar Sep 26 '17 13:09 sadomovalex