post meta - What type of index should I use for postmeta?

admin2025-06-04  2

I already added a composite index but it still took 5 seconds to finish these 2 queries.

SELECT COUNT( DISTINCT( wpp.id ) ) 
FROM `wpdgls_posts` wpp JOIN `wpdgls_postmeta` wpm ON wpp.id = wpm.post_id
WHERE wpm.meta_key = '_form_id' AND wpm.meta_value = '14' ;

SELECT COUNT( DISTINCT( wpp.id ) ) 
FROM `wpdgls_posts` wpp JOIN `wpdgls_postmeta` wpm ON   wpp.id = wpm.post_id
WHERE wpm.meta_key = '_form_id' AND wpm.meta_value = '14' ;

Here are my index:

KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`(191)),
KEY `meta_value` (`meta_value`(255)),
KEY `wp_meta` (`post_id`,`meta_key`,`meta_value`(8))

Should I use FULLTEXT index on meta_value?

转载请注明原文地址:http://conceptsofalgorithm.com/Algorithm/1749005289a315549.html

最新回复(0)