Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Performance] Quote Reply And Too Much SQL Queries
#1
Not Solved
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 ??


Attached Files Thumbnail(s)
       
#2
Not Solved
This is not default behaviour, which plugins do you have installed?
[Image: banner.png]
#3
Not Solved
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
#4
Not Solved
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.
#5
Not Solved
(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.


Attached Files Image(s)
   
#6
Not Solved
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).
#7
Not Solved
Sql Queries

Index: 9
Normal thread: 25
Thread with with 3-4 quote reply: 44
Thread with GD, Quote, Thanks: 57
#8
Not Solved
The problem is the thanks plugin and maybe the google seo too.
#9
Not Solved
i managed to reduce the sql queries by disable the google seo url
#10
Not Solved
If you disable it just for users, that will suffice, may be.
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)