Hi. We have problem with MySQL Performance Issues with extremely Slow Queries from td-composer. Our hosting company says that we need to contact to theme developer with this. They gave us some logs most slow query
Log homepage:
Log posts pages:
Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ===== ====== ===== ==============
# 1 0xB737CB04793C3C01 350.9329 26.2% 174 2.0169 0.04 SELECT wp_posts wp_postmeta
# 2 0x6DB65FF8AB06C471 304.0139 22.7% 1225 0.2482 0.13 SELECT wp_posts wp_term_relationships
# 3 0x7EDD67F850C9495A 161.2269 12.0% 1188 0.1357 0.17 SELECT wp_posts
# 4 0x706652A6B0287162 156.6832 11.7% 983 0.1594 0.26 SELECT wp_posts
# 5 0x20373A9E62F5C1C9 81.3103 6.1% 472 0.1723 0.18 SELECT wp_posts
# 6 0x6D8F0C88575ADD79 80.4559 6.0% 474 0.1697 0.20 SELECT wp_posts
# 7 0x92F3B1B361FB0E5B 35.5572 2.7% 314 0.1132 0.09 SELECT wp_options
# 8 0x6FE68E4BC98E6BF2 21.8973 1.6% 200 0.1095 0.07 SELECT wp_posts wp_postmeta
# 9 0x15F3C7642D334030 17.9180 1.3% 104 0.1723 0.30 SELECT wp_terms wp_term_taxonomy wp_term_relationships
# 10 0x1BA583FA1E24E5EE 16.3957 1.2% 76 0.2157 0.10 SELECT wp_posts wp_term_relationships
# 11 0x42CA2150EDE6716A 13.8584 1.0% 80 0.1732 0.11 SELECT wp_posts
# 12 0x7D18C5C503757896 12.4813 0.9% 124 0.1007 0.00 SELECT wp_postmeta
# 13 0xC89E060FE92799F6 11.8437 0.9% 51 0.2322 0.30 SELECT wp_terms wp_term_taxonomy
# 14 0x6C36E27CDB31213D 6.8317 0.5% 68 0.1005 0.00 SELECT wp_postmeta wp_posts
# 15 0x12321DB68B8BC9A8 6.4205 0.5% 13 0.4939 0.24 SELECT wp_posts wp_term_relationships wp_postmeta
Hi pyro2212, we are using the queries from WordPress, but our developers adapted the code to our theme needs.
Please make sure that all the settings are like in our requirements, please follow the guide carefully
– https://forum.tagdiv.com/requirements-for-newspaper/
and please increase all requirements that are lower, and follow all steps.
Make sure that you do not have extra plugins that interfere with the theme queries.
Let me know the results!
We are sure – all the settings are like in your requirements. And we sure queries coming absolutely from your theme. We made sure of this by disabling the related posts block and slow queries gone. But now another slow query has now been detected. It comes from td-composer next-prev posts. It turns out the only way to make your theme work quickly is delete everything?
https://d.radikal.ru/d11/2012/da/3c59531e4e12.png
I do not understand why such technical support is needed. They cannot help even in basic things from the theme that they created.
Hi,
All those query are for each block that has filters on theme, also if has extra ajax filters then are more query add. Unfortunately, in this way was made the theme by developers when the blocks were made. Now I’m not a developer, I’m only a support member and I do not have enough knowledge about how to improved those queries in the theme files, but I make a notice to our developers to improve the queries from our theme.
Thank you for your understanding!
Hiii Calin Sir…
I have Posted my Problem on Forum Please Find and Solve my Problem.
Please Help me and Solve my Problem.
Thanks
