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

[WordPress Trac]

#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
 [https://stackoverflow.com/questions/13846691/adding-limit-clause-to-
 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