Performance difference between Query.Where and Query.EQ

XMLWordPrintableJSON

    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Hi,

      I am performing many update operations and I see a performance impact when using Query.Where instead of Query.EQ.
      The queries are:

      Query<SomeObject>.Where(x => x.Id == someId)
      Query<SomeObject>.EQ(x => x.Id, someId)

      Creating 10000 queries takes 115ms when using the EQ query and 4500ms when using the Where query.

      Why is there a difference between the two? Could you explain what the difference is?

      Thanks,
      Eitam

              Assignee:
              Unassigned
              Reporter:
              Eitam Belahousky
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: