[wp-trac] [WordPress Trac] #55463: Add a limit to _prime_*_cache functions

WordPress Trac noreply at wordpress.org
Wed Apr 13 21:46:26 UTC 2022

#55463: Add a limit to _prime_*_cache functions
 Reporter:  spacedmonkey                     |       Owner:  spacedmonkey
     Type:  enhancement                      |      Status:  assigned
 Priority:  normal                           |   Milestone:  6.0
Component:  Cache API                        |     Version:
 Severity:  normal                           |  Resolution:
 Keywords:  good-first-bug has-patch commit  |     Focuses:  performance

Comment (by spacedmonkey):

 In my tests of 1000 requests, the difference was.

 Before - 0.379
 After - 0.366

 I am also seeing improves on single requests.

 Before - 0.0005
 After - 0.0004

 I saw similar results in multiple test runs. The improve is not as much as
 I hoped but it something.

 Limits normally do improve the performance a query, as they allow queries
 to stop early. But looking at this
 mysql-query-slows-it-down-dramatically thread], it seems that the improve
 only comes when query is against a non indexed field.

 TLDR, This patch is an improvement, but it not much as hoped.

Ticket URL: <https://core.trac.wordpress.org/ticket/55463#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list