[wp-trac] [WordPress Trac] #57683: Improve performance of mysql2date

WordPress Trac noreply at wordpress.org
Mon Mar 13 19:27:35 UTC 2023


#57683: Improve performance of mysql2date
--------------------------+--------------------------
 Reporter:  spacedmonkey  |       Owner:  (none)
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  6.3
Component:  Date/Time     |     Version:  0.71
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:  performance
--------------------------+--------------------------
Changes (by flixos90):

 * milestone:  Future Release => 6.3


Comment:

 I ran a quick performance benchmark on this PR (added the code manually to
 WP 6.2-RC1):

 *
 [https://docs.google.com/spreadsheets/d/11-xJsSsNks55Hr07AQ6kMuUj4h1AUMCTSKQNXlbCNEI/edit#gid=1501750953
 Classic theme data]
 *
 [https://docs.google.com/spreadsheets/d/11-xJsSsNks55Hr07AQ6kMuUj4h1AUMCTSKQNXlbCNEI/edit#gid=1575808113
 Block theme data]

 Both tests were run on a home page with 2 posts, and the improvements are
 between 0.4-0.9ms. It is expected that the improvements would be slightly
 larger the more posts are on a page.

 While it may seem like a small improvement, every improvement counts, and
 their effect adds up eventually. So together with the existing support on
 the approach, I think it makes sense to commit it as it definitely has a
 positive performance impact.

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


More information about the wp-trac mailing list