I am running an audit with the Query Monitor plugin to determine why has my website become slow again, after some time when it ran somewhat good (not excellent though…). To my surprise I discovered that for every page load there are 27 database queries that fall under the “SLOW Queries” category. Please mind that *ALL* 27 out of 27 slow queries belong to the td-composer.
Please advise what we need to edit (if it is something we can fix on our end), in order to make the page perform better than this. Surely there must be something that can be done. 8+ seconds is a very long time for a front page to load on a 1 Gbps internet connection.
Hi,
I just checked your website and I saw that you have some canceled resources in console https://i.imgur.com/EKSV51P.png those take a part of the loading time of your page, I think that if you can fix/remove those elements or make theme to load, the web page will be load faster, then maybe the 27 database queries will not be such a big problem. Also those queries can be made the the blocks that you have on page, each one has different settings, therefore, it will be make a request for each one of them.
Also I note this on our list to see if we can not improve those queries.
Thank you!
I think this is not the right answer for his problem. It’s an internal problem.
Using groupby in sql statements in connections with a lot’s auf joins is not good
solution. Here is much to optimize in the theme-code.
The sql-quieres seams to be inefficient codes.
Can you please fix that with your team.
reproduce: create 100k Post / 30k taxonomy
– use the theme in version 11.1
– an than optimize the queries/theme with query monitor.
Thx for help.
Hi mbrckn,
I didn’t say that the connections from queries can not be improve, but from my test on my install, there were no slow queries -> https://i.imgur.com/GmZTFUr.png sometimes the slow queries can be from other extra code, plugins or specific settings.
Anyway, I informed our developers to check the querist made by our theme and see how can those be improved.
Thank you for your understanding!
Please do, as from a different panel of the same plugin’s (Query Monitor) I can see that TD-Composer’s queries by far outnumber all the other queries made on page load. 314 compared to a remainder of less than 70 queries for the rest of the plugins. And the total time needed to execute those queries effectively kills our efforts towards a better SEO score, and/or to speed up the serving speed of the site. Including browser caching it!
Hi Redlemon, if you are agree, we’ll like to check this situation on your website, since for us the results are different, if you are agree and you have the possibility, please set a subdomain or staging and set there a copy of your live website, in this way when we’ll inspect the situation, the live website will not be affected. Once that you set the live site on staging/subdomain, please contact us at contact@tagdiv.com and provide wp-admin and cPanel access, we’ll check it as soon as possible.
Thank you!
Hi,
I am experiencing slow queries also and it’s killing the SEO and making server space moe expensive.
Are there any updates on this issue?
Thank you
Hello @m!
I recommend you to have the latest version of the PHP, WordPress, theme and plugins(11.4).
The Standard Pack plugin is an old one with old features with default templates. We do not recommend it anymore. We encourage you to use the cloud templates.
Documentation here:
– https://forum.tagdiv.com/cloud-library-templates/
– https://forum.tagdiv.com/design-post-pages-using-cloud-library-templates/
– https://forum.tagdiv.com/cloud-library-category-templates/
Check also our video tutorials here: https://www.youtube.com/c/tagdivThemes/videos
Also, some tips here:
– https://wpartisan.me/tutorials/wordpress-database-queries-speed-sql_calc_found_rows
– https://css-tricks.com/finding-and-fixing-slow-wordpress-database-queries/
– https://wordpress.org/support/topic/slow-database-queries-from-mariadb-slow-query-log/
– https://www.rackaid.com/blog/wordpress-slow-speed-up/
Maybe your hosting provider can provide some advice as well.
Thank you!
I’m also having troubles that my website is so slow, it even times out. Investigating the problem it turns it’s having 25 repeating slow queries on a ‘post’page looing and ordering the same post ID 39081:
SELECT post_id, meta_key, meta_value
FROM F5A9liKgu_postmeta
WHERE post_id IN (39081)
ORDER BY meta_id ASC
update_meta_cache()
Plugin: td-composer
Hi Dibbes,
On thing that can be done is to replace all standard templates with cloud templates and disable the tagDiv Standard Pack. This is loading all resources even if those are not used.
About the DB queries, if those queries are inside the post, it can be only form the elements that are displayed inside that post.
Thank you!
Hi Calin,
Thank you for your response.
Is there more information / explanation how to replace these templates with a minimum downtime and without messing up layout? In what way I can do this?
Hi,
You need to make sure that all your templates are from cloud, this can be done easily if you install a pro demo, but before this please make a full backup. (steps to disable the standard pack).
The second method required some more time, but is better. What you need to do is to import the cloud templates from tagDiv Cloud Library and assign them (replace the homepage, category, author posts, header, footer,.. templates ). After all those are done, disable the tagDiv Standard Pack, if there are no shortcode on website, then you replaced all standard elements, but if there are, the set back that plugin and replace that element.
Also you can make those changes on subdomain and when everything is done just transfer theme on live website.
Thank you!
Hi Calin,
I have been digging on my old tickets, and I found this. I would like to share my feedback. I have replaced all tagDiv Standard Pack modules with Cloud Templates, and have also disabled TDSP, but I am still having 8 slow queries in the front page of my site. I have opened a different ticket for that case, but I would like to share the knowledge with fellow TDC users.
Same here.. Still have these issues
Hello,
This problem is still on our list of investigations, we did tests but we still could not reproduce the problem.
Thank you for your understanding!
could not reproduce the problem?!
Hi,
On websites for testing, everything seems fine. Maybe the problem may arise from a specific setting that is not configured on our websites.
Thank you!
