Question Kunena Performance FAQ

I have recently been asked about performance of Kunena. I'd like to shine some light on the current and upcoming versions in terms of performance.

First of all let me make it clear that the number of queries executed is not a very good measurement of performance. It is the type of queries and how well they are optimized. A single slow query can do more harm than 100 fast queries.

We are very well aware of past performance problems with FireBoard and plenty of improvements did already make it into the code.

While we are currently focusing on rolling out 1.0.8, we already have the performance improvements for version 1.1 working, just not yet integrated and tested. The changes to the underlying database tables are too significant to be included in the current 1.0.8 release.

On large forums we have seen a drop of up to 90% in mysql load through these changes.

It's coming in the next few weeks. And I am sure you will like the results. It will make Kunena a very fast forum software to run. Joomla native, fully integrated and fast.

A caution on comparing number of queries: If you rely on Joomla to tell you how many queries a component runs per page, you cannot use that comparison for any software that uses bridges. If you run a 3rd party forum software that requires a bridge, Joomla will not be aware of the queries run by that component and the debug output will be totally off and incomplete.
You might think you run only 12 queries for that page, while the software underneath runs 100+ queries that do not showup in your report.

You have our commitment to make Kunena a fast solution. As I said, lots more improvments are already in the funnel.

Have a great day!

fxstein

Stop losing time here
Just open notepad and write code
Kunena 1.0.7 need a lot of improvement
plz can u make 1.0.8 before this week end
the only big problem i have is upload avatar

Thats uncalled for in my opinion etusha. The developers are working hard already and have fixed many bugs already in the SVN.

In all cases the super team for the work they have done.

Thanks

peetree21 wrote:

Thats uncalled for in my opinion etusha. The developers are working hard already and have fixed many bugs already in the SVN.

I think t was meant as a joke.

@fxstein

is there a limit to what kunena can handle? how big could a board go without adverse performance? could it handle 1,000,000 threads and 30,000 users? my site is nowhere near that yet (120,000 and 5,000 users) but just curious.

I guess this depends on server setup as well. My server is:

Linux VPS
15,000 MB Disk Space
70 GB Data Transfer
768 MB RAM Guaranteed
32 GB RAM Available
Full Root Access
Fully Managed Solution
2 IP addresses

PHP Built on: Linux host.website.com 2.6.18-028stab057.4-ent #1 SMP Fri Aug 1 13:37:30 MSD 2008 i686
Database Version: 5.0.67-community
Database Collation: utf8_general_ci
PHP Version: 5.2.6
Web Server: Apache/1.3.41 (Unix) PHP/5.2.6 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
Web Server to PHP interface: apache
Joomla! Version: Joomla! 1.5.9 Production/Stable [ Vatani ] 9-January-2009 23:00 GMT
User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6

Any advice much appreciated.