[wp-trac] [WordPress Trac] #37965: Add post_last_activity column to posts database table

[WordPress Trac]

#37965: Add post_last_activity column to posts database table
-------------------------------------+------------------------------
 Reporter:  johnjamesjacoby          |       Owner:  (none)
     Type:  feature request          |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Posts, Post Types        |     Version:
 Severity:  normal                   |  Resolution:
 Keywords:  2nd-opinion needs-patch  |     Focuses:  performance
-------------------------------------+------------------------------

Comment (by johnjamesjacoby):

 @thelmachido your approach mirrors the work done by @netweb in the bbPress
 Trac, so that’s a good thing!

 https://bbpress.trac.wordpress.org/ticket/1925

 I do still think a new column in the table would be ''best'' (even if it
 is unlikely) – it’s much simpler (at least for me) to understand & use,
 and is as human readable as the existing datetime columns.

 Thank you for your example and for giving this some attention and thought.
 I appreciate you chiming in with such a thorough & helpful reply. I’ll
 think about using COALESCE again. 👍

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/37965#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform