Freddie, you so smart... and it appears usergroupid is already indexed. So his original showthread join with the user would not have been a problem eh? Sorry intellected! I see you already changed it to use a new field, post.hellban. If the original way really didn't add much overhead, it was probably the more elegant solution rather than adding a new field to post.
|