WordPress Query is taking more then 20 second and stuck on creating index
Looking at your query, I see lots of stuff like wp_posts.post_content LIKE ‘%اهمية%’. You should know that column LIKE ‘%matchstring%’ is a notorious MySQL performance-killer. If you can change your operations to use column LIKE ‘matchstring%’ (with no leading %) this will get better. Or, maybe it makes sense for you to adopt a search … Read more