Hello,
We are facing huge about of delay when we open any post. The index page seems to be fine without any slow query. This is what happens when i’m clicking on the post, I’ve put the detailed query screenshot. Kindly advice asap
Servers are = 24 Core CPU and 32GB RAM.
Hello football5,
Please notice that the speed of your website depends on how well your site is optimized. Please notice that this is not a simple task and if you do not have any experience in this regard you will do not bring good results for the theme. Also, notice that we have a speed optimization tutorial but this is addressed only to advanced users. So, if you follow the steps which are presented in this tutorial here -> https://forum.tagdiv.com/how-to-make-the-site-faster/ you can increase the page speed loading and if you are not aware of the steps in this regard, please consider hiring a freelancer/developer to help you because the speed optimization services is not covered by our support policy, as you can read here -> https://forum.tagdiv.com/support-policy-2/ Check our documentation here -> https://forum.tagdiv.com/requirements-for-newspaper/ regarding on dedicated server to fit to our requirements.
Hope this helps!
Thanks for your understanding!
The same thing!
We have 2 days with an specialist servers looking for this origin.
The site works fine but internal linking (links added manually on the posts for SEO purpose), sometimes it takes many seconds.
I thought I was the only one
Hi Nairolf,
Did you use fresh DB or imported? For my server as soon as we view second page, it takes more than 10 seconds with only 50 visitors on site. as soon as i hit 100 the site dies even with high CPU hardware spec. I’ve done all the optmization required and using Akamai CDN system to ensure the speed, But yet i’m getting the error i shared.
Any idea Catalin?
Hi Football5,
Was fresh 🙂 but is a clean DB (allways theme and only 3 plugins: VC + Yoast Premium + Speed Booster), I mean without residual stuff.
So the circle is little: theme or one of this 3 plugins.
I’m not sure, maybe is Yoast 3.7.0/1 coze I see something in his support forum. Right now seems that Speed Booster plugin even if move CSS/JS to the bottom, Google throw render-blocking for all content less the homepage.
I don’t want to downgrade for the moment to Yoast 3.5.2 because I want to see if we can replicate again the slow down for internal linking.
VPS – Memcached / Zend OPcache – all pages load in 0,3 – 0,5 sec.
Hello football5,
First of all, please make sure you meet the requirements for newspaper: https://forum.tagdiv.com/requirements-for-newspaper/ and increase your system status parameters according to this guide: https://forum.tagdiv.com/system-status-parameters-guide/
Also, if you are using the Visual Composer on posts, please try to disable it for this because the VC is not tested on posts, and you can encounter some delays because of this. Clear all your caches and test it again.
Thanks for your understanding!
Hi Catain & nairolf,
I may have found the issue with the speed, there is pagination on each post, that is the one which is taking allot of resources and making our site slow. Our query time to pull that is more than 10 seconds. Definately there is a bug or some sort.
Query Caller Component Rows Time SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND ( wp_postmeta.meta_key = ‘post_views_count_7_day_total’ AND ( mt1.meta_key = ‘post_views_count_7_day_last_date’ AND CAST(mt1.meta_value AS SIGNED) > ‘1476098794’ ) ) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS SIGNED) DESC LIMIT 0, 5 WP_Query->get_posts() wp-includes/query.php:3645 + Theme 5 9.8114
Please let me know where to fix this and how?
Hello football5,
Unfortunately, I do not exactly understand of what query you are referring to. You should make some tests through creating a new page for testing where you will have to add a block and change the sortings. (popular, random, latest, etc) and you must identify the origin of this issue. Eventually, you can change and the filters wich can influence because all of these are consumer memory. You will have to make deeper investigations in this regard to find the cause of problems. However, I suspect the popular 7 day filter to cause this issue. Try to change it and check the results.
Thanks for your understanding!
