This topic has 4 replies, 2 voices, and was last updated 7 years, 10 months ago ago by Eva Kemp
Hello,
I never had this problem before, but it looks like the Legenda theme is causing my website running slow. When I change to theme Twenty Fifteen, the website is runnig smooth again.
Wordpress 4.7.2.
When Legenda theme is active, I can see the following query (MySQL process) causing the delay which is locking other tables:
| 1316 | comqiddie-dallas | localhost:54792 | comqiddie-dallas | Query | 164 | Sending data | SELECT COUNT( DISTINCT wp_posts.ID ) as term_count, terms.term_id as term_count_id FROM wp_posts
INNER JOIN wp_term_relationships AS term_relationships ON wp_posts.ID = term_relationships.object_id
INNER JOIN wp_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )
INNER JOIN wp_terms AS terms USING( term_id )
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id AND mt3.meta_key = ‘_wc_sw_max_price’ ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) LEFT JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id )
WHERE wp_posts.post_type IN ( ‘product’ )
AND wp_posts.post_status = ‘publish’
AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (5383,5380,5379,5381)
AND object_id = wp_posts.ID
) = 4
AND
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (5402)
AND object_id = wp_posts.ID
) = 1
AND
wp_term_relationships.term_taxonomy_id IN (5383)
) AND (
( wp_postmeta.meta_key = ‘_visibility’ AND wp_postmeta.meta_value IN (‘visible’,’catalog’) )
AND
( mt1.meta_key = ‘_stock_status’ AND mt1.meta_value = ‘instock’ )
AND
(
(
( mt2.meta_key = ‘_price’ AND CAST(mt2.meta_value AS DECIMAL) BETWEEN ’10’ AND ‘9999999999’ )
AND
mt3.post_id IS NULL
)
OR
(
( mt4.meta_key = ‘_price’ AND CAST(mt4.meta_value AS DECIMAL) <= ‘9999999999’ )
AND
( mt5.meta_key = ‘_wc_sw_max_price’ AND CAST(mt5.meta_value AS DECIMAL) >= ’10’ )
)
)
)
AND terms.term_id IN (5382,5379,5380,5381,5383,5384)
GROUP BY terms.term_id |
credentials
new credentials
Hello,
Due to GTmetrix result https://gtmetrix.com/reports/qiddie.com/YozPhCyD , please follow the suggestions from these articles:
https://varvy.com/pagespeed/scaled-images.html
https://varvy.com/pagespeed/leverage-browser-caching.html
https://varvy.com/pagespeed/defer-loading-javascript.html
http://www.elegantthemes.com/blog/tips-tricks/optimize-images-for-your-wordpress-website
Also you can use some additional plugins for compression, caching (W3 Total Cache etc), image optimization (WP Smush etc.) and Javascript / CSS Minifiers. These can optimize and speed up your website.
Regards,
Eva Kemp.
You must be logged in to reply to this topic.Log in/Sign up