Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24044, comment 75


Ignore:
Timestamp:
03/13/2019 01:13:10 PM (6 years ago)
Author:
tofandel
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #24044, comment 75

    initial v1  
    44
    55With query debug enabled you can see a lot of slow options queries before taking 0.08s, and then they all disappear when the index is added
     6
     7We can also take it further and add an index on option_values of size 20 because the query of update_transient does a lookup on the option_value and is therefore super slow (0.06s each seriously),
     8I added this index as well and the performances went from 2s to .5s all the transient update queries now take 0.0001s
     9
     10Also each update transient does the request 2 times (for the timeout as well) and the index of 20 will make sure that the timeout is always indexed (I think it fits in 16 chars if I'm not mistaken)