Why doesn’t WP prefix length index “autoload” column, under wp_options table??
Such query patterns are always slow:
Count: 124 Time=25.76s (3194s) Lock=1.81s (224s) Rows=515.3 (63893), 3users@19hosts
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘S’
1) In almost all cases one can create an “autoload” prefix length index to resolve the issue and speed up the query.
2) The autoload column can also be shortened instead of doing the prefix lenght index as this column almost never holds values outside of: “YES” or “NO”. So make it a VARCHAR(3) alternatively?
This problem is near and dear to many users. Believe me I know. This will help many many many WP customers!
Can WP consider a WP plugin update, sometime soon on this issue?
Please get back to me.
[sig moderated as per the Forum Rules]
- The topic ‘Prefix the length of indexes’ is closed to new replies.