Home
Forums
New posts
Search forums
What's new
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
XenForo bug reports
Bug reports
Merging Post performance issues
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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>
[QUOTE="PaulB, post: 1531215, member: 56853"] 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. [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
XenForo bug reports
Bug reports
Merging Post performance issues
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top