Important Slowness in Kunena due to Many Categories

thats not important for Kunena as I say Kunena1.6 DO NOT support cache


Note:Im not Kunena dev

Hi guys,

Greetings from cold Shanghai, China!

Lots of good observations here.

There is no single simple answer because it all depends on many factors.

The main factors that drive performance are:

• Server performance
• Server configuration: e.g. APC configured properly, MYSQL configured properly
• Kunena integration options: This can have a significant impact to large sites. Currently jomSocial has the best performing integration as they support user data prefetch. We collect all the users that are listed on any given page and make one call to load all at once = 1 sql query no matter how many users are shown (topic creator, last reply, active users, ...) - other 3rd party integrations do not yet support this kind of user data prefetch which makes some of these solution run 1 query per user listed - same for the avatar integration on large pages
• SEF: We currently do not know of any 3rd party SEF component that is fast enough to handle the complex URL workload of a large forum. A solution like sh404SEF can almost bring your server down if a forum exceeds 20-30,000 posts and more complex index structures
• Extra plugins and modules on the forum pages: This can be endless

You can easily test this for yourself: Turn on Joomla debug mode and record the number of queries and the amount of memory consumed.

With APC enabled and installed properly you should see less than 10MB of memory consumed for the most complex pages and less than 40 queries (including the Joomla queries - which runs 18-20 by itself) per page.

Any more memory or queries needed point towards other plugins, modules or components and their integration. You can test by disabling e.g. 3rd party integration and re-recording the memory and query stats from the Joomla debug mode.

I would recommend for any performance questions to include the configuration report + snapshots of the joomla Debug output for the pages in question.

Last but not least the Joomla cache can be beneficial - even on Kunena pages, as additional modules like advertisements or custom module still benefit from caching.

Hope this helps!