[wp-trac] [WordPress Trac] #15499: Add an index for get_lastpostmodified query

[WordPress Trac]

#15499: Add an index for get_lastpostmodified query
------------------------------------+-----------------------------
 Reporter:  simonwheatley           |       Owner:  SergeyBiryukov
     Type:  enhancement             |      Status:  reviewing
 Priority:  normal                  |   Milestone:  6.2
Component:  Database                |     Version:  3.0.1
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:  performance
------------------------------------+-----------------------------

Comment (by rjasdfiii):

 Ollie's two 3-column indexes versus my one 4-column index:

 * It is hard to predict which would be better overall.
 * More indexes has a slight burden on disk space and INSERT/UPDATE time.
 * The longer index is slightly slower for the GMT usage for it.

 Without a good enough benchmark to choose between them, I would flip a
 coin.

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