[bigskyry]

We have a fairly sizable install of bbpress at backpackinglight.com/forums.

We upgraded to the newest version of 2.6.x last week, and are noticing two very significant negative impacts:

The time between hitting the “post” button on a new post, and waiting for the post query to finish, has tripled. When the site is busy, it now takes more than 30 seconds.

As such, users are hitting the button twice which results in double posting.

Is there anything we can do to optimize these queries to improve performance?

[suranodsk]

I advise you to roll back to the previous version. If you want to stay on this version, then connect site monitoring and statistics collection host-tracker.com For example, this tool will help you determine the problem of the poor functioning of your site.

[bigskyry]

@suranodsk yes, we’ve been through quite a lot of analysis.

The primary issue is that the new post select and post write queries are taking about 3x longer on 2.6 than on the latest previous version of 2.5.x, and we’re trying to figure out why.

We’ve run extensive new relic tests and it has isolated the specific queries as the culprit. Otherwise, there’s no other issues with our host or our site that is causing the slow query times.

So, there’s something in the new 2.6.x bbpress query engine that seems to be less efficient for large databases than in the 2.5.x query engine.

Sure, we can toss a bunch of server resources, PHP workers, and REDIS at it, but that doesn’t really fit into the bbpress “light and simple” ethos. Lots of performance improvements promised, but when the rubber met the road…

We’d rather figure out what’s going on structurally with bbPress 2.6 vs. 2.5 than just give up and downgrade to 2.5.

[Robin W]

have you run

dashbard>tools>forums>upgrade forums ?

[bigskyry]

Yes, we ran all of the scripts that were noted as “critical” right after the upgrade.

[Robin W]

ok,

@johnjamesjacoby can you help here ?