Wel I hope you are still around to answer a couple of questions. First, I would like to have seen it running because I would like to know how it got to 430. Also - I could do with ane explanation on the 'every wordpress page' comment because the forum doesn't run any queries on any page other than the one it displays in. So it would have been useful to get to the bottom of it. There isn't really a way it can 'slow down a whole site'.

While it is an ongoing task with every release to optimise wherever possible and reducing the amount of queries is taken very seriously and is a continuing task and goal there are four comments I would make.

The first is that MySQL is a remarkably robust engine and is very good at cacheing. The vast majority of the queries you refer to are taking place in memory and are returnng very small chunks of data which, from a properly optimised and indexed database is not an issue or a strain. Sites generally will suffer far more slowdown from poorly constructed php code than they ever will from data retrieval. And whenever I am shown a slow site it is, without exception, always down to (a) a cheap host dividing up resources between too many websites and (b) sites that are littered with too many 'widgets' plugins and fancy bits and pieces with no thought to performance. Certaiinly one likes to keep the query count down as much as possible but it is a myth to believe that every query exponetially skows down page retrieval. Sites that load 22 style sheets with every page (and I saw one of these just last week) because of badly written plugins are bever going to load fast and are always going to be cpu hungry.

Secondly, we tend to give people what they ask for. Our users have made many, many requests for features and being the nice guys we are we tend to add those new features in. It is interesting to note that between V2.1 and V3.1.3 the query count actually went down but the codebase went up as, new features need to be coded. But a huge effort has also gone in to, and is contunuing to go in, to ensurng that less and less code is actually loaded per page. This has, regardless of what the guy above said, actually made it faster. Many users who have been with us for some time have remarked upon this which is satisfying. But… more featires and bells and whistles will inevitably makde the coe base bigger and add to  database interaction.

The third and one of the most important points is that we have been despertaly trying to keep support going for users on older versions of MySQL. Again most of the cheaper hosts are still using what is, in technology and software terms, pretty old and ancient versions of MySQL. When we decide we can support these no longer and move to more recnt version only there is much that can be done to reduce queries and improve performance. Newer version support stored procedures, sub-queries and views etc., all of which can be most beneficial.

The fourth point is that ths plugin is built upon WordPress. That offers both a plus and a minus. The plus is that it means a totally integrated forum which can not be done with other, bigger systems such as Simple Machine of phpbb and this has been something that users want. The downside is that WordPress will still need to do all the things that WordPress does - including all the queries it has to run - before handing off control to the forum plugin. The guy above with his alleged 430 queries has not broken that down to how many are purely down to the forum. Neither have you.

And I guess that finally I should add the obvious comment. If you are unhappy with it then please do not use it.

I need Mr Papa for this one as he can always remember the numbers but I know of at least three users whose membership is numbered in the thousands (if I recall correctly) as are their number of posts. They have reported ni slow down whatsoever. (Perhaps Mr papa can verify later on). At the end of the day it's not how many users and how many posts you have - it's how many concurrent users.

I wish you were correct about the MySQL version. It has a similar take up to hosts using php5.

But are you still talking about ALL pages running slow when SPF is activated? Because that really doesn't make sense. And 430 queries is far too high although ne eway you can build up the number of queries is to have a arge number of forums - but I do mean quite a large number.

My feelings were not hurt by the way. It takes quite a lot to hurt my feelings. I get angry at times like to the guy who sent me an email with a support question (and it states I don't do suport via email) and when I replied asking him to direct his question to the forum came back and said my support 'sucks'. That one made me angry as I spend hours sitting in front of this screen doing my best to help people. But a lttle constructive criticism is just fine.

Yes i wantet to ask how many peaople could be active ( online wirting posts etc ) at the same time without killig the server

Ill wait for mr.Papa

Mhm ok would benice to know if someone other knows in the forum please tell me

Whoops - yes - I forgot the RSS feed question. For private feeds you have to set up http authorisation on your server. I'm really not sure how that is set up but a search should turn something up. It isn't straghtforward though.

are you guys around? i could turn the forum on now if you want to see it… please contact me by e-mail if you want to.