MySQL takes too much

[pstdgt]

Page generated in 1.69623303 seconds (8.80% PHP - 91.20% MySQL) with 27 queries.

This is what my forum's index page footer shows most of the time, although the time in which the page is generated may wary according to the active users amount. I think it's TOO MUCH MySQL in there. I have installed the caching hack for the index.

Can anyone give me a hint to optimize the vB database in order to reduce the MySQL percent?

[filburt1]

The best advice is always to just get rid of unnecessary hacks. Stock vB uses (IIRC) less than 20 queries for forumhome, so you have at least 7 extra queries from hacks or badly-written hacks that don't cache all templates.

[Xenon]

hmm it depends on which hacks you use.
the dynamical style dropdown hack for example uses a very slow query, once i cached it on vb.org it speeds up the mysql part about 10 times

[pstdgt]

thank you for your replies.

normally, the index uses 34 or so queries, but because of the caching hack, after the first index load the query number is usually 27.

what is the dynamical style dropdown hack? the one which allows users to "collapse" forum categories?

[Xenon]

hmm the chaching hack shouldn't be out anymore afaik?

i released version 2 of forumhome optimization without that sort of caching.

nope it's not that hack.
it was just an example, that some hacks can slow down a page very strong and others nearly unmarkable

[pstdgt]

danke.