Right, let's not talk about vB5 . How does it look as compared to most other XF installations? I've enabled the widget framework add-on on all the pages so wondering if everything is in good condition. Anything I should look at optimising or fixing?
The default query count for a thread is around 11.
So you've got 14 extra queries.
If you click on the number of seconds it will bring up a very detailed view of what queries are being run. This should tell you what add-ons are generating them.
Sometimes, add-on developers forget to cache a template or a phrase which can generate a query. This obviously adds up over time. Also, I have seen a few bugs in old versions of add-ons whereby the same queries kept running. One was actually Nodes as Tabs I think clashing with DigitalPoint Ads Positioning and it kept running the same query over and over. This was quite quickly fixed but sometimes we don't always update add-ons straight away so if you do identify add-ons with an unexpected query count then maybe updating them will solve the problem.
Also if you have Widget Framework installed, make sure you are caching the widgets. I think the cache setting is in the PHP file for the renderer. You would have had to manually edit these files to turn the cache off. If you've done this, then this will potentially generate a large number of queries on every page load when it might only need to generate 1.
This is my forum home (with Widget Framework and have them caching):
Timing: 0.1074 seconds Memory: 6.846 MB DB Queries:13 Forum:
Timing:0.0663 seconds Memory:6.125 MB DB Queries: 13 Thread:
Timing: 0.0654 seconds Memory: 6.565 MB DB Queries:11