Database query very slow with just one addition

Do you have the field indexed?

Fields you use like that should all be indexed for speed look ups.

Ah, good suggestion. It is not indexed, I will give that a try tomorrow and see if it fixes it.

Actually, my bad, I completely forgot about indexing. Thanks for the suggestion.

Paul.