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>