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 plugin for WordPress and bbPress Forums
Enhance, expand and optimize bbPress powered forums

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.

Latest From The Blog

wordpress happy birthday wordpress turns 21

Happy Birthday: WordPress Turns 21

21 years young and still going strong, WordPress powers nearly half of all Internet websites and is the most used CMS by a large margin over the competition, with a very active development cycle, showing no signs of slowing down.
tutorials wordpress debug mode benefits and pitfalls

WordPress Debug mode: Benefits and Pitfalls

Developers know how to best use debug in WordPress and WordPress WP_DEBUG constant to get through potential problems and bugs their code might have. But, for regular users, using debug mode can be very confusing and cause more problems than it can help solve.
plugins relase corsecurity 1 9

coreSecurity Pro 1.9

coreSecurity Pro 1.9 brings several very important bug fixes (related to the file scanner), several new features related to antispam control, user session management, improvements to the file scanner, and more.

Leave a Comment

Grammarly - Number 1 Writing App
WP Rocket - Make WordPress Load Fast in a Few Clicks