Reply to thread

Message: <blockquote data-quote="PaulB" data-source="post: 1531215" data-attributes="member: 56853"><p>Part of the issue here appears to be that none of the applicable indices on xf_post include message_state.  Most page views need to filter on message_state, and Thread#rebuildReplyCount filters on message_state as well; those queries are going to be much slower than necessary.  Both require counting based on at least one criterion that isn't included in the index, and counting that way is quite slow.</p></blockquote><p></p>