>Tore
>
>Further to my last reply to this message, I've now tried the following, with NO improvement. This is totally baffling me that something can be so slow. Weird thing is I got it to go really fast on Friday then it reverted to impossibly slow again, and I can't see what changed in between.
Perhaps you want to try the following. In principle, a condition like:
...WHERE Field1 + Field2 + Field3 = Value1 + Value2 + Value3
can be faster than a condition on:
... WHERE Field1 = Value1 AND Field2 = Value2 AND Field3 = Value3
... assuming you have al requried indices. In the first case, you would need a compound index with the expression
Field1 + Field2 + Field3.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)