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>

Verification

We value your privacy

We use essential cookies to make this site work, and optional cookies to enhance your experience.

See further information and configure your preferences

Accept all cookies Reject optional cookies
Essential cookies

These cookies are required to enable core functionality such as security, network management, and accessibility. You may not reject these.

Optional cookies

We deliver enhanced functionality for your browsing experience by setting these cookies. If you reject them, enhanced functionality will be unavailable.

Third-party cookies

Cookies set by third parties may be required to power functionality in conjunction with various service providers for security, analytics, performance or advertising purposes.

Detailed cookie usage

Privacy policy

Top Bottom