It’s just checking if the activity has been “flagged”, and if there is a value it has been, so it should not be shown.
(Even if I reduce per_page=2 it’s still the same amount of slow)
Oddly, if I change it to “EXISTS” it’s very speedy. Only difference because only a few posts have that particular meta_key applied to them. I don’t understand why this is though because regardless if the key exists or not, the DB query check has to be performed. So why is it faster?
Thank you. This is what I figured, but was wondering if there’s any strategy or extra parameters/changes that would speed it up? Aka using number comparison instead or something, since you mention the idea of one being faster than another.