Sometimes - on some queries I have seen a 20% difference on 30-60 seconds of execution time. Looking at the job inspector the key difference seems to be that the :: filter applies before lookups and field calculations, so that less overall "work" gets done - if you have no auto lookups or calculated fields that may be why we see such different results.
The more events that the :: operation filters out the better the performance gain
For a historical search - so the same number of events are involved (58,963 in scope, 48532 matching) I see the :: search do:
1.99 command.search.calcfields 13 48,532 48,532
and
0.77 command.search.lookups 13 48,532 48,532
While the = search does:
2.58 command.search.calcfields 12 58,963 58,963
and
1.05 command.search.lookups 12 58,963 58,963
I need to try on 6.3.2 before raising a support ticket.
... View more