Blog Post

GD bbPress Toolbox Pro 4.3.4

GD bbPress Toolbox Pro 4.3.4 is a minor release that deals with performance issue of the statistics function that could potentially lead to slow SQL response on pages where that function is used.

Function for getting forum statistics ‘gdbbx_get_statistics()‘ was relying on bbPress own ‘bbp_get_total_users()‘ function. And that one was using WordPress own ‘count_users()‘ function. This last function is marked as very slow SQL query function and it can lead to performance issues. If you have a lot of users in the database, this performance issue can lead even to server crashing. It has surely crashed Dev4Press server a few times already over the past few months, and we have found evidence of it in the MySQL logs. WordPress uses this function on the Users panels, and you can notice issues there too. I can’t do much about WordPress, but I can change GD bbPress Toolbox Pro to stop depending on the function that is obviously a problem. Hopefully, WordPress core team will revisit this function and improve it.

To remedy this issue, and to stop using this WordPress function, I have created a new and simpler function for counting users, and the whole statistics function output is cached for a period of one hour. This will lead to generating statistics once every hour and avoid running 20+ SQL queries to count various forum information every time function is called.

If you notice any problems with the plugin, stop by the support forums to report it. Let me know what you think about the new version, and as always, suggestions are welcome.

Please wait...
GD bbPress Toolbox Pro
Enhancing WordPress forums powered by bbPress

Expand bbPress powered forums with attachments upload, BBCodes support, signatures, widgets, quotes, toolbar menu, activity tracking, enhanced widgets, extra views...

About the author

Milan Petrovic
Milan Petrovic

CEO and Lead developer of Dev4Press Web Development company, working with WordPress since 2008, first as a freelancer, later founding own development company. Author of more than 250 plugins and more than 20 themes.

Subscribe to Dev4Press Newsletter

Get the latest announcements, release digests, promotions and exclusive discounts, and general Dev4Press-related news straight into your mailbox.

This form collects your email (optionally your name) for the purpose of sending you newsletters. Check out our Privacy Policy for more information on how we store and manage your data. We will not send you any spam. Newsletters are sent 2 to 4 times every month.

Leave a Comment

SiteGround - Managed WordPress Hosting
GeneratePress - The perfect lightweight theme for your next project