Database saturation due to theme issues.

Posted in: Newspaper
Post count: 28

We are getting lots of saturation issues due to your theme issues, we are advised to do following, plese check

I have gone through your issue, and it seems that your site is running WordPress. The query itself seems to be originated from the theme and although we would be able to alter the theme’s core codes, it would make the theme be blocked from future updates. Additionally, since the nature of the site is a “News Portal”, the site would naturally consume a lot of resources due to running the queries in parallel. I would suggest implementing any remote caching tools, such as nitropack.io or asking the hosting provider to implement Redis Caching to the Database, so the load on the server would reduce.

Please help us to fix the issue.

Thanks

Post count: 21065

Hello @transcontinentaltimes!

Did you use some caching tools for the database? Let me know the results!

Thank you!

Post count: 28

Please read this Post, it is clearly the Theme issue.

https://forum.tagdiv.com/topic/very-slow-query-because-of-most-popular-news/

Please let us know how to fix this, as we have said that…

We have followed the above steps and we have done all the activities, disabling, deleting and installing plugin and cleared the cache and issue still persist. This is serious issue and coming from Theme only. We need solution on this.

Our Hosting provider says.. Can you please help us on this… This is causing issue as below SQL queries from theme are taking so many resources.
_—————
Your SQL queries are still a problem at the server level, we have told you this several times.
Here are some examples:

| 10426 | qyjm9184_prod | localhost | qyjm9184_tct | Query | 0 | Sending data | SELECT DISTINCT tct_posts.* FROM tct_posts LEFT JOIN tct_term_relationships AS ppma_tr ON ppma_tr. | 0.000 |
| 10427 | qyjm9184_prod | localhost | qyjm9184_tct | Query | 1 | Sending data | SELECT DISTINCT tct_posts.* FROM tct_posts LEFT JOIN tct_term_relationships AS ppma_tr ON ppma_tr. | 0.000 |
| 10428 | qyjm9184_prod | localhost | qyjm9184_tct | Query | 0 | Sending data | SELECT DISTINCT tct_posts.* FROM tct_posts LEFT JOIN tct_term_relationships AS ppma_tr ON ppma_tr. | 0.000 |

Post count: 21065

Hello @transcontinentaltimes!

We are still investigating these issues and trying to find an efficient solution and will implement it in the next updates.

Thank you so much for understanding!

Post count: 84

Have you implemented any efficient solution on versio 12? I’ve repórter the same issue more than 6 months ago and requested investigativon by your team.
.

Post count: 84

Have you implemented any efficient solution on versio 12? I’ve repórted the same issue more than 6 months ago and requested investigativon by your team.
.

Post count: 35449

Hi mita, you can check the changelog from themeforest, there is a list with all that has add and fixed for the Newspaper 12 -> https://themeforest.net/item/newspaper/5489609 -> https://i.imgur.com/nmcoPsM.png if the mentioned problem is not on that list, that means it is still on developers list to be fixed.
Thank you for your understanding!

Post count: 28

Dear Calin,

As most of the users are facing the Database saturation due to theme issues. Do you know when we can expect the fix on this serious and critical issue?

Due to this issue, website is confusing high resources which causing crashing the site. Hope this will be address urgently.

Post count: 35449

Hi transcontinentaltimes,
I sent an email to the developer team asking when we can expect this problem to be resolved, now I’m waiting for an answer from them.
What I can recommend is to use cache on database and mysql-> https://code.tutsplus.com/tutorials/speed-up-wordpress-caching-and-database-optimization–cms-22055 -> https://wordpress.org/plugins/mysql-query-cache-stats/
Thank you!

Post count: 28

Hi
We are still waiting for the update. When those issues will be fixed?

Post count: 35449

Hi transcontinentaltimes,
Our developer implemented an option that will be added in the coming theme update and should fix/improve the theme requests to the database.
Thank you!

Viewing 11 posts - 1 through 11 (of 11 total)
The forum ‘Newspaper’ is closed to new topics and replies.