Advertisement
rAthus

[SQL] WordPress index table postmeta

Oct 12th, 2023 (edited)
1,322
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.67 KB | None | 0 0
  1. # description: creates indexes to speed up by a factor of 10+ complexe queries that use meta queries!
  2. # instrcutions: execute each of these queries once on your database to create the indexes, change the "wp_" prefix if needed.
  3. # downside: the index tables can use a lot of space, be sure to check on your database size.
  4. # caution: the creation of these indexes can be super heavy, better try on a preproduction database before doing it live.
  5. # also: using these indexes shouldn't prevent you from optimizing your queries as much as possible anyway ;)
  6. CREATE INDEX idx_key_value ON wp_postmeta(meta_key, meta_value(10));
  7. CREATE INDEX idx_postid_key ON wp_postmeta(post_id, meta_key);
Advertisement
Comments
Add Comment
Please, Sign In to add comment
Advertisement