Hi.
We are using your theme and we are facing the following issues, as mentioned in the subject.
Can you let us know how to solve these? Our db is indexed in full. Seems like we need to optimize those queries in app level.
http://prntscr.com/m8o1te
and
http://prntscr.com/m8o2ao
might be helpful
Hi,
I did some researches and I found some documentation that may help you
-> 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/
– https://forum.tagdiv.com/cache-plugin-install-and-configure/
– https://forum.tagdiv.com/how-to-make-the-site-faster/
– https://www.infophilic.com/get-almost-100-pagespeed-newspaper-theme/
– https://forum.tagdiv.com/topic/score-100100-pagespeed-with-newspaper-wordpress-theme/
– https://forum.tagdiv.com/topic/newspaper-theme-speedify-your-website/
– https://forum.tagdiv.com/topic/tutorial-chriss-custom-optimizations-for-functions-php-etc/
– https://forum.tagdiv.com/cloudflare-cdn/
– https://forum.tagdiv.com/topic/theme-causing-high-cpu-usage-2/
– https://forum.tagdiv.com/topic/sql-querys-high-cpu/
– https://forum.tagdiv.com/topic/newspaper-theme-slow-to-respond/
– https://premium.wpmudev.org/blog/optimizing-your-wordpress-database-a-complete-guide/
– https://underconstructionpage.com/optimize-wordpress-database/
– https://crunchify.com/better-optimize-wordpress-database-all-in-one-guide/
Hope this will help you.
Thank you for your understating.
Hi Catalin.
I didnt ask for a Google search.
I pasted specific queries that come from your td composer and they are heavy enough, so I am asking for a rewrite of them, in order to be more effective and less resources-eaters.
Hi themesic,
Please note that I’m Calin, not Catalin.
Those queries usually are for pagination, or filters from pages, you can deactivate ajax dropdown and pagination, clear all cache and try again, see if those slow queries are still there.
Thank you for your understanding.
Hi,
Yest that it is possible, but I can not say for sure couscous my code skills are not so high.
Thank you for your understanding!
Can you escalate it to the devs please for review?
It seems to me tat its caused by theme’s counting functionality for. popular posts since if i change counting to JetPack for populars, slow query gets away.
I just need a verification – i know that such a query could be heavy on a heavytraffic website.
Hi,
The sort order for popular all make a request to all post that you have in data base, when if you are using the JetPack for popular will be sorted only the posts that have received the most traffic in the past 48 hours, so in this case the request to database will be much smaller.
Thank you for your understanding.
Got it.
Any ideas on how to get over this slow query? If a database grows enough during a day, it will also cause issues even at a 48hrs query.
IE use of Analytics API ?
Hi,
Unfortunately I do not know a solution for this, but we’ll try to investigate this problem and in coming updates we hope to make our theme faster then now;
Thank you for your understanding!
Calin, what about duplicate queries?
Hi,
The duplicate queries still appear after you get read of the slow queries?
Thank you!
Yes, they do still exist.
Hi,
You can check this topics -> https://wordpress.org/support/topic/600-duplicate-queries-to-wp_options/
->https://wordpress.org/support/topic-tag/duplicate-queries/
Also if is possible please check on a new install and see if this problem appear, is possible that this problems to appear during the building website, using plugins.
Thanks.
Did you tried on your demo and you were not able to reproduce the same?
It also happens with disabled plugins.
Hi,
We tested on our site and this was the result -> https://www.screencast.com/t/EPw5IRSiSuG7
Please make sure that the theme system status is configured as mentioned in the requirements guide. Please follow the guide carefully
– https://forum.tagdiv.com/requirements-for-newspaper/
and please increase all requirements that are lower, and follow all steps.
Please check the php version, is possible that you have an old version of php to gave a slow query.
Thanks.
Thank you for your answer Calin.
I am gonna reopen this ticket if needed.
Hi Calin,
Now I am facing duplicate queries issues …
I read in the forum and made all the optimisations.
1 / The server corresponds precisely to the requests (php.ini, php functions, etc …
2 / Wp cache is set according to your specifications
3 / I deleted all the ajax drop downs and the previews / next on the blocks.
4 / I deactivated all the plugins, and …
I still have a lot of duplicate queries ( tagdiv composer)
I don’t know what to do now!
Thank you for your help.
Olivia
Hi oliviaparis
Please provide me a link to your website to see what it is contain, in this way I will be able o tell what you can edit to improve the situation with duplicate queries, usually these can be related on the elements that has set next/prev buttons, maybe the live search, infantile loading.
Thank you!
