MyBB Community Forums
[Performance] Quote Reply And Too Much SQL Queries - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Performance] Quote Reply And Too Much SQL Queries (/thread-121996.html)

Pages: 1 2


Quote Reply And Too Much SQL Queries - gamemaster - 2012-07-06

Ok.. Just want to ask.. is it real that quote reply using too much sql resources ??

My normal thread sql queries without quote is around 25-30 but when it having too much quote reply it goes to 50-60 sql queries.

Any ideas how to reduces the sql queries ??


RE: Quote Reply And Too Much SQL Queries - StefanT - 2012-07-06

This is not default behaviour, which plugins do you have installed?


RE: Quote Reply And Too Much SQL Queries - gamemaster - 2012-07-06

not so much.

1. Subforums in column
2. Google SEO
3. Mapovifog
4. Image Resizer & Optimizer with GD
5. Minimum Posts Required to Get Access
6. My Ad Manager
7. Sig Image Size
8. Thanks button


RE: Quote Reply And Too Much SQL Queries - Omar G. - 2012-07-06

Can you share "Minimum Posts Required to Get Access" link?

And which plugin is "Thanks button" exactly (link)?

Most probably one of those is the problem (Thanks button is my guess), but can't find them to check.


RE: Quote Reply And Too Much SQL Queries - gamemaster - 2012-07-06

(2012-07-06, 07:53 PM)Omar G. Wrote: Can you share "Minimum Posts Required to Get Access" link?

And which plugin is "Thanks button" exactly (link)?

Most probably one of those is the problem (Thanks button is my guess), but can't find them to check.

minimum post required is from Yaldaram plugin.

and for the thanks button plugin.. http://mods.mybb.com/view/thanks

Ok. just SS this statistic..

This is thread with one quote reply and without any thanks or GD image resizer plugin.


RE: Quote Reply And Too Much SQL Queries - Omar G. - 2012-07-06

The thanks plugin is not optimized, and with Google SEO it gets worse, because it probably needs to run one query for each link that plugin builds.

(Also, try to refresh one page before taking screenshots of the stats).


RE: Quote Reply And Too Much SQL Queries - gamemaster - 2012-07-06

Sql Queries

Index: 9
Normal thread: 25
Thread with with 3-4 quote reply: 44
Thread with GD, Quote, Thanks: 57


RE: Quote Reply And Too Much SQL Queries - Omar G. - 2012-07-06

The problem is the thanks plugin and maybe the google seo too.


RE: Quote Reply And Too Much SQL Queries - gamemaster - 2012-07-07

i managed to reduce the sql queries by disable the google seo url


RE: Quote Reply And Too Much SQL Queries - Omar G. - 2012-07-07

If you disable it just for users, that will suffice, may be.