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: 1531240" data-attributes="member: 56853"><p>Might be better to keep the indices the way they are and use [ICODE]post_id[/ICODE] instead of [ICODE]post_date[/ICODE] as the last column in the ORDER BY clause. Reasoning:</p><ol> <li data-xf-list-type="ol">post_id is already at the end of the thread_id_position index, albeit implicitly.</li> <li data-xf-list-type="ol">post_date isn't going to preserve order anyway in popular threads that have replies within a second of each other.</li> <li data-xf-list-type="ol">post_id isn't perfect, but it's good enough here, since the post_id ordering is only applicable to hidden posts. Any hidden posts that are between the same two visible posts will retain that positioning; they just might be out-of-order relative to each other.</li> </ol></blockquote><p></p>
[QUOTE="PaulB, post: 1531240, member: 56853"] Might be better to keep the indices the way they are and use [ICODE]post_id[/ICODE] instead of [ICODE]post_date[/ICODE] as the last column in the ORDER BY clause. Reasoning: [LIST=1] [*]post_id is already at the end of the thread_id_position index, albeit implicitly. [*]post_date isn't going to preserve order anyway in popular threads that have replies within a second of each other. [*]post_id isn't perfect, but it's good enough here, since the post_id ordering is only applicable to hidden posts. Any hidden posts that are between the same two visible posts will retain that positioning; they just might be out-of-order relative to each other. [/LIST] [/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