Slow down WordPress : SELECT DISTINCT meta_key FROM wp_postmeta WHERE meta_key NOT BETWEEN ‘_’ AND ‘_z’ HAVING meta_key NOT LIKE ‘\\_%’ ORDER BY meta_key LIMIT 30
I have fetch some issue when many records exist in post meta, so below query i found into Query Monitor WordPress plugin that was taking too much time to execute SELECT DISTINCT meta_key FROM wp_postmeta WHERE meta_key NOT BETWEEN ‘‘ AND ‘_z’ HAVING meta_key NOT LIKE ‘\%’ ORDER BY meta_key LIMIT 30 That query is […]