Changes between Initial Version and Version 1 of Ticket #24044, comment 75
- Timestamp:
- 03/13/2019 01:13:10 PM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24044, comment 75
initial v1 4 4 5 5 With 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 7 We 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), 8 I added this index as well and the performances went from 2s to .5s all the transient update queries now take 0.0001s 9 10 Also 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)