Yeah. This forum for example uses 5 queries on a load of the discussions page. And from a quick glance, I think the actual main content is just made by one big-ass query. If you have discussion overview enabled you have 4 queries instead of that single big-ass one. I think.
Yep, what mini said.
3-4 queries to generate the discussion grid isin't that bad. 15-16 however is a different story
Changing the number of viewed discussions per category only changes the amount of data sent between database and Vanilla... a tiny amount of time. But assembling the discussion grid is one of the most complex queries to do, and in dovforums case, multliply that by 16 for every homepage reload.
There is nothing wrong with discussion overview--just using it with many categories.
FTR, I was not criticizing the add-on. Can't see a better way of doing this (other than perhaps some minor query caching (5 secs?) to reduce peak loads for concurrent users.
I would however be a BIG proponent of a core-level 'code profiling ON/OFF' setting to profile (time) all queries and/or add-ons. There is precious little info available to review performance problems/requirements other than the full page load time measurements (also see previous topic http://lussumo.com/community/discussion/4476/ and referenced tools such as the vanilla timer plugin, plus firefox add-ons tamperdata & firebug)
Comments
some minor query caching (5 secs?) to reduce peak loads for concurrent users.
I would however be a BIG proponent of a core-level 'code profiling ON/OFF' setting to profile
(time) all queries and/or add-ons. There is precious little info available to review performance
problems/requirements other than the full page load time measurements (also see previous
topic http://lussumo.com/community/discussion/4476/ and referenced tools
such as the vanilla timer plugin, plus firefox add-ons tamperdata & firebug)