Yes, we ran all of the scripts that were noted as “critical” right after the upgrade.
@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.
Yes, this sort of hack would certainly work.
These forums aren’t *that* big. Why is this a problem? Is it a problem with bbPress?
@casiepa They’re not big forums – up to a few hundred topics and up to several hundred replies only. We have about 120k topics and 800k replies in our forum db overall.
We’re on an enterprise class server at WPEngine, so it doesn’t seem like we should be running into problems.
Yes, we’re trying to hit the “Trash” link from the All Forums list.
