Performance update

XenForo has the table xf_thread_user_post which contains  a cached copy of a user's post count in a thread.

This table is automatically managed, and updated on moderation actions.

Using this table, allows the query against a thread with 58803 posts, and 692 users to take ~0.3 seconds vs ~5 seconds (or 11 seconds with a cold DB cache)