Interesting forumcache from the datastore slowing board down

[eXtremeTim]

vb3's forumcache in the datastore brings the whole forum to a crawl with enough forums. load times without the forumcache being unserialized are .04-.06 with it being serialized my load times jump to .45-.8

Anybody have any ideas on how to improve this? This is horrible. My site has a great number of forums. The board is fairly hacked up right now but none of them are the cuase I have spent the last 6 hours tearing the board apart and tracked it down for a fact to be the forumcache in the datastore that is used for displaying all the forums. It slows down every page that is tied into the vbulletin becuase of the case switch's used in init.php for unserializing everything. There is just that much info that the cache is trying to parse out. not all these forums are listed on one page. I have some code that I made a while back that allows multiple forum listing pages. This code is highly optimized and not the problem. I know none of my code changes are the problem becuase I went back to stock files about 3 hours ago and still had the exact same loads. I am very experienced with vbulletin and php/mysql.

If anybody has any ideas on a way to speed the forums back up please let me know.

Please dont say remove some forums. That is not helpful. If that was what I wanted to do it would have been the first thing I did to fix the problem.

Just checked the forum cache size and it is almost 455kb big. Thats 455kb of stuff that vbulletin has to wait till its unserialized each time even on pages that dont call forums. Such as the faq.

[rake]

This has been discussed before, but i don't know if a solution has been found. I remember reading several threads about this on vb.com. The forumcache is number of forums * number of usergroups large, and where there are many forums, it can get quite large.I've seen sites with a forumcache as large as a couple of MB.

You should search, then ask on vb.com.

[Andreas]

Hmm ... interesting point.
It might also affect other big caches too.

Brainstorming

• remove unnecessary columns from table forum (left over from hacks that are no longer being unsed, etc.)
• shorten variable names for hacks that add colums to table forum
• optimize build_datastore()

Gonna take a look into this.

[Andreas]

Hmm ...
http://bugs.php.net/bug.php?id=31332