Search in dashboard
-
Hi.I stay in version 3.3.0
All others new version is slow in search to find a product.
I have try all to disable plugins theme.I checked all.
I have 12.000 products but work very well until version 3.3.0 after this version the search is terribly slow (Take 13 seconds to find a product).I ask for your help.Thanks
-
no solution yet… tried almost everything available online ??
If i run the following query on the SQL DB manually, it looses the connection.
SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
FROM wp_posts posts
LEFT JOIN wp_postmeta postmeta
ON posts.ID = postmeta.post_id
WHERE posts.post_type IN (‘product’,’product_variation’)
AND ( ( ( posts.post_title LIKE ‘%samsung%’)
OR ( posts.post_excerpt LIKE ‘%samsung%’)
OR ( posts.post_content LIKE ‘%samsung%’ )
OR ( postmeta.meta_key = ‘_sku’
AND postmeta.meta_value LIKE ‘%samsung%’ ) ))
ORDER BY posts.post_parent ASC, posts.post_title ASCIf i just run it on post.title it works, looks like all those joins are making it fail….
SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id FROM wp_posts posts LEFT JOIN wp_postmeta postmeta ON posts.ID = postmeta.post_id WHERE posts.post_type IN (‘product’,’product_variation’) AND ( posts.post_title LIKE ‘%samsung%’) ORDER BY posts.post_parent ASC, posts.post_title ASC
- The topic ‘Search in dashboard’ is closed to new replies.
