bbPress.org

The cost of Deep Integration

Published on July 2nd, 2010 by kevinjohngallagher

I’ve spent the last week working with a client on a rather large WP/bbP setup. One of the real joys of this project is that it’s large enough for me to get some time in for more than asthetics and QA. Hence, a few more posts her this last week and some code, and some BackPress help.

Anyway, one of my junior developers came up with an interesting stat the other day that I’ve been looking into, namely Deep Integration and it’s hit/performance. I’m sure almost all of this will be obvious to a great many of you, but I thought I’d throw out some figures.

Single Loading of software after install

WordPress2.9.2		16 database queries

WordPress30			19 database queries

bbPress0.9			09 database queries

bbPress1.0.2			16 database quieres

Single Loading of software after setup

WordPress2.9.2		19 database queries

WordPress30			23 database queries ***1

bbPress0.9			10 database queries

bbPress1.0.2			18 database quieres

Now the first thing I noticed is that WP3.0 took a leap in queries. Once it takes you 20+ queries to load a simple homepage with no plugins my spider sense is tingling. Turns out that WP3.0 is somewhat sruggling with it’s new menu system. ***1 It takes 6 queries minimum, plus 1 query for each taxonomy type used in the new menu (apart from hardcoded links with don’t get an additional query). That’s a heck of a leap for something as simple as a menu. I mean, menu’s are rarely dynamic – they don’t change that often. For this particular website, as will probably be the way for the others I’ve moved to WP3.0, I’m looking at a minimum of 8 database queries simply to load the data needed to display the name and link in a menu. To be clear, that’s over 30% of database queries on a clean install of WordPress that are being called by this.

As cool as the drag/drop facility is, make every menu item a custom link and you’ll save a minimum of 2 db calls per page load.

Even better, hardcode the actual menu and save yourself 8 database calls per page load (you can hardcode an array for the walker class to iterate through and produce the same result)

Single loading of software after basic/core plugins:

Now, I believe that no WordPress (nor bbPress) install can run as expected these days without certain plugins. Your thoughts on this may vary ofcourse but I find that I need a minimum of WP-Super-cache, XML-sitemaps, WP-security-scan, wp-pagenavi, headspace/All-in-one, WP-stats, and probably a few others that I can’t remember off the top of my head. Oddly for bbPress I need more plugins.

WordPress2.9.2		23 database queries

WordPress30			27 database queries ***1

bbPress0.9			18 database queries

bbPress1.0.2			29 database quieres

That’s quite a leap. But I’m confident that I could bring down the bbPress Queries with some time spent considerably, and I could enable caching from WordPress. I’m not posting this data in itself as definative stats for everyone, so there could be optomization made for sure.

Deep Integration of WP3.0 and bbPress1.0.2:

WP3 &amp; bbP1			56 database quieres

56! With virtually no caching availible (as a plugin, for the average user with no .ini or shell access).

56! On every page (+/- a few queries).

Deep Integration of WP3.0 and bbPress1.0.2 – after first pass:

WP3 &amp; bbP1			43 database quieres

Ok some quick theme changes and delayed/circumvented loading of certain things and I’ve brought it down considerably.

But the fact still remains that this is a truly crazy amount of database queries per page load.

Anyway, after presenting this (in a better looking format) to the IT director of the client, I’ve managed to re-assign myself 2 weeks to come up with a planB. We want something that allows us the functionality of Deep Integration, but without the MASSIVE overhead. I have an idea down on paper, but right now I just wanted to post a few figures and give folks a heads up.

==================================================================================

Edit: If you want to see something fun, try this:

Add to your bb-config.php and your wp-config.php

In bb-config.php and wp-config.php add the following line:

define('SAVEQUERIES', true);

Then add the following code to your footer.php in your theme (right at the bottom)

wordpress footer

global $wpdb;

echo &quot;[pre]&quot;;

print_r($wpdb-&gt;queries);

echo &quot;[/pre]&quot;;

bbpress footer

global $bbdb;

echo &quot;[pre]&quot;;

print_r($bbdb-&gt;queries);

echo &quot;[/pre]&quot;;

*** replace the square brackets [] html brackets (they’re not showing up correctly)

bbPress Security

Published on July 2nd, 2010 by pagal

Can I use this wp plugin for bbpress?

< ?php

Plugin Name: Block Bad Queries

Plugin URI: http://perishablepress.com/press/2009/12/22/protect-wordpress-against-malicious-url-requests/

Description: Protect WordPress Against Malicious URL Requests

Author URI: http://perishablepress.com/

Author: Perishable Press

Version: 1.0

global $user_ID;

if($user_ID) {

if(!current_user_can(‘level_10’)) {

if (strlen($_SERVER) > 255 ||

strpos($_SERVER, “eval(“) ||

strpos($_SERVER, “CONCAT”) ||

strpos($_SERVER, “UNION+SELECT”) ||

strpos($_SERVER, “base64”)) {

@header(“HTTP/1.1 414 Request-URI Too Long”);

@header(“Status: 414 Request-URI Too Long”);

@header(“Connection: Close”);

@exit;

}

And tell me how can I make my forums more secure?

Nedd Tips and Tricks!!

And did anyone make any security concern plugin for bbpress?

Thanks,

Pagal

Does this work with WordPress 3.0 (Multi-User) ? Where can I find instructions?

Published on July 1st, 2010 by masterlock1

I’ve recently ungraded to WordPress 3.0(Multi-User). The instructions referenced here: http://wpbbpthemes.org/integration/ are for an earlier, single-user version. Any feedback would be appreciated. Thanks.

Installation question

Published on July 1st, 2010 by world2010

I am wanting to use this on my site, I am needing to know if it’s okay to install while the site is already created with members and do I need buddy press. Any help you can give me will be very appreciated.

Cannot Login After Install

Published on July 1st, 2010 by ethanthekiwi

I am running WordPress 3.0 on a Turnkey Linux based server that is my own (not hosted). I downloaded the latest version (1.0) of bbPress and put it in /var/www/wordpress on my server. I went to mysite.org/bbpress (that’s not my actual domain, but it’s an intranet site anyway so it doesn’t matter) and went through the installer. I created a mysql database and everything else. I skipped integrate with WordPress (for now) and the installer worked. I went to mysite.org/bbpress and I could see the front page of the forum and everything looked fine. When I try to log in using the Key Master username and password I got from the install, I get sent to a page with:

Warning: Cannot modify header information – headers already sent by (output started at /var/www/wordpress/bbpress/bb-config.php:1) in /var/www/wordpress/bbpress/bb-includes/backpress/class.wp-auth.php on line 273

I went and deleted everything and started over with the same result. I don’t know if it means anything, but I didn’t get an email from the site with the Master Key password either. Can anyone give me an idea of what I might be doing wrong? I not a coding expert, but I can usually figure these kind of things out. I would really like to use bbPress as it looks like the best forum for my users (which includes a wide range of people many of whom are not technologically savy). If you need any more technical details let me know. Thanks in advance.

Theme not working!!!

Published on July 1st, 2010 by

I’ve integrated bbpress on top of my wordpress installation

http://shoeynet.com

http://shoeynet.com/forums

No matter what I do, I cannot get the themes to work, all permissions are right and they are all in the right place, but I think it’s conflicting, I think wordpress is trying to take ownership of the theme files instead of bbpress

Can someone please help

(Because of issue, I’ve taken out link to forums from wordpress page)

Can I add form fields to the registration page?

Published on July 1st, 2010 by plinth

Title says it all – I’d like to add a couple of extra fields to the registration form, like an ID number and make them mandatory too. Is this possible?

Cheers

Do you use WordPress Deep Integration? could you answer two questions please?

Published on July 1st, 2010 by kevinjohngallagher

Howdy,

I’m after some feedback folks, and I’d really apprecaite anyone who could spare some time to jot me down some quick answers:

If you use Deep Integration for a bbP/WP install, could you please list the reasons why?

What data, if any, do you pull into your forum via a WordPress function?

What WordPress plugins are displayed on your forum?

Any and all data from any level of bbPress user would be really really helpful.

Thank you,

Kev

Arcade plugin ideas

Published on July 1st, 2010 by j0hnny

http://quickarcade.jcink.com/index.php

Anyone ever thought about integrating these two things together? Either that or porting over a plugin like IBPArcade or v3 Arcade? Maybe even coming up with an original plugin. I dunno it was just a thought. Maybe someone else has already thought of it.