[Performance] Quote Reply And Too Much SQL Queries

[gamemaster]

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 ??

[StefanT]

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

[gamemaster]

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

[Omar G.]

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.

[gamemaster]

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.

[Omar G.]

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).

[gamemaster]

Sql Queries

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

[Omar G.]

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

[gamemaster]

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

[Omar G.]

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