Here is wpForo

wpForo average response time was a little less than HALF of bbPress.

However, it still was nowhere close to non-wordpress based forum software so I ran a profile on a page where I was reading a topic.

wpForo executed over 360 SQL queries just for reading a topic.

Compare that to my old phpBB forum which only executes 16.

Although a nice improvement over bbPress, it just doesnt perform fast enough for our clients 🙁

I could run 30 phpBB forums on the same hardware versus wpForo.

I also suspect that because wpForo does not use a unique INTEGER ID in its url's it is forced to run a SQL query against a CHAR column when searching for topics.  This is very slow when dealing with a forum that has 300K or 1 million+ posts.

I would suggest tweaking your software to add a unique postID to each URL for much faster queries.

And finally, please reduce the number of queries. Would love to use this software but I need it 10X faster than it is today.

Checked on a query.

"SELECT *

FROM `wp_wpforo_topics`
WHERE `slug` ="   /etc

This is where you guys find the post via the slug. The query is surprisingly fast, so I stand corrected.  Doesnt seem to be a need for a unique INTEGER in the URL.

It seems the huge number of queries, all which are individually fast, when added together, cause a high load and a sluggish site.   > 1 second response time is too slow.