[Nitac]

Been running a bbp forum for a couple of weeks after migrating from phpbb (thanks a lot for writing the migration scripts). Though the forum seems to be going ok ive been getting a lot of users complaining about how long it takes to post a reply.

There are about ~470k replies and ~15k topics so there is a fair amount of content, it’s running on AWS with EC2 m1.medium server and RDS db.m3.medium database so there’s plenty grunt there.

So was wondering if there’s anything I could be doing optimise bbp or if anyone knew if some server config that may help.

Thanks

[Stephen Edgar]

We have a rather large performance increase coming up in bbPress 2.6 that will address most of your issues, primarily it relates to the sort order of topics as we have a slow database join when we need to sort the topic order based on the latest reply.

[Nitac]

cool cheers, how close are you guys to releasing it so I keep the users at bay?

Thanks

[Stephen Edgar]

It’s the same answer as “How long is a piece of string” at the moment, and if the planets align I should be able to give you a respectable answer to this question by the end of the week, not the next release, just an answer to the question 😉

[Nitac]

haha yeh I hear ya, thanks

[Nitac]

if I could get my forum posting anywhere as quick this site I’d be stoked, cheers.

[Nitac]

can anything be done in the mean time?

I’m starting to lose users because of the slow performance.

thanks

[Robkk]

Do whatever you can to speed up your website.

click the link

http://lmgtfy.com/?q=how+to+speed+up+my+wordpress+website

[Nitac]

no need for that dude.

rest of the site is fine this is specifically related to how long it takes users to post in the forum.

maybe you should have read all the replies before responding.

[Robkk]

haha i read everything

what i just doing is lead you to a google search , it was suppose to help you to find info that might help you

any kind of information is good when trying to speed up a website.

i dont know if you use alot of bbpress plugins or plugins that work with it and you need to optimize scripts and css handling.

or if your forums have alot embedded images or uploaded images.

or that you need a database optimizer plugin

im just trying to help you on a pretty broad question

i wasnt trying to be rude or anything if you took it that way

other than that i guess wait til 2.6

[Nitac]

when i respond using LMGTFY its normally a dig at the other person, so hopefully you can see why i took it ‘that’ way. but i’m going to move on.

ive eliminated all the points you’ve made above, and the site only chokes when users are submitting posts in the forum, so I’m confident i’ve isolated the issue.

as mentioned i’m coping heaps of flack for the performance of the forum and losing users so i hope you can appreciate why there’s an element of urgency.

[Robkk]

when i respond using LMGTFY its normally a dig at the other person

XD haha alright

ive eliminated all the points you’ve made above, and the site only chokes when users are submitting posts in the forum, so I’m confident i’ve isolated the issue.

great!! i was hoping you did , because any second shaved in loading helps.

as mentioned i’m coping heaps of flack for the performance of the forum and losing users so i hope you can appreciate why there’s an element of urgency.

post more information about how you are setup on your site. (this is good for support of others users)

do you have threaded replies active? (this always took awhile to load on a reply for me)
do you have the forum on root? (some huge bbpress forums i saw have the forum on a subdomain)
do you have a cdn? (i checked two huge forums that use bbpress and they use cloudflare)

here are the forums
http://tamrielfoundry.com/forums
http://www.highexistence.com/discussions

and also can you post a link to your forum?

[Robkk]

nevermind on the CDN

but do post a link to your forum

i actually want to see how long it takes to load

[Nitac]

http://killyourstereo.com – the main forum is private

Server : AWS EC2 m1.medium
DB : AWS RDS db.m3.medium
CDN: AWS S3 (currently only serving images)

Here’s a breakdown of the site: http://builtwith.com/killyourstereo.com let me know if any other info would help.

Not using anything crazy from a plugin perspective either:
ACF
BBPress
Quick Cache Pro (caching only for guests at the moment)
All in One SEO

and few other plugins.

– No threaded replies
– The forum is on the root, hadn’t really considered moving but it feels like its more of a db issue.

at the moment its taking about ~15seconds to reply

cheers

[Stephen Edgar]

I saw this pop up on my phone whilst I was out and wasn’t even going to try to chime whilst mobile. Anyways, I’m just going to have some dinner but whilst I eat that I’m generating a test site with a few hundred thousand posts to test a plugin, this “might” help but I’ve never tested it before, so give me half an hour and I’ll let you know.

[Robkk]

~15seconds to reply

hell id be pissed too if its 15 seconds

ok im going to be signing up for your website in a minute , and ill see first hand on these slow replies.

but hey if you want your users to stay active on your forum , i think using tapatalk might help for a while as your users wait til you get this help on your replies on your websites actual forum but yeah im not sure on this.

crazy alternative while this gets fixed is make a subreddit. (i seen sites do this)

or of course stay active on other social media sites like facebook or twitter

[Stephen Edgar]

Two things, the plugin I thought would help actually makes things worse, didn’t expect that, though the second thing, running what I ‘thought’ should work that I have tested previously also now doesn’t work. 🙁

I’ll need to test both of these tomorrow, and I’ll update things then, depending on the solution we are talking a range of 50-90% improvement in performance, so why either of these options is failing for me at the moment I’m unsure.

[Nitac]

ok cool, thanks for looking into it Stephen really appreciate it.

cheers

[Robkk]

@mchl did the reply submitting slow down after you installed a specific plugin??

cause i read the new site topic on your private forum, and it seems that users only started to complain about reply submitting being slow after you installed some plugins like unread posts and go to first unread posts.

if it was always slow wait til @netweb gives you some info and ill do more research on the problem, if it was until you installed the plugins deactivate them and see if it makes a difference.

[Stephen Edgar]

Firstly, a quick breakdown via pingdom, quite a delay in getting your JavaScript files, I’d get these into your Amazon CDN.

As you stated above “ive eliminated all the points you’ve made above, and the site only chokes when users are submitting posts in the forum, so I’m confident i’ve isolated the issue.”

• What happens when you deactivate either/or “Go to first unread” & “Unread posts” plugins you’re using and submit a reply to an affected topic?
• Another test, this time with the ‘Quotes’ plugin disabled submit a reply to an affected topic.
• Another, what code and/or plugin are you using to show the user registration in each reply e.g. Join Date: Mar 2009
• And another, what code and/or plugin are you using for the counts shown next to the username in each reply e.g Posts: 4529

Can you run the following two queries in phpMyAdmin, it will give me an idea of the state of the data in your database, it is the topic and three replies (two imported replies and one new bbPress reply) from the ~10k topic you have:

SELECT ID, post_author, post_parent, menu_order, post_type
FROM  wp_posts
WHERE  ID
IN ( 490979, 831628, 837704, 1031603 ) 

and

SELECT * 
FROM  wp_postmeta
WHERE  post_id
IN ( 490979, 831628, 837704, 1031603 ) 

Once you have the results of each (they don’t show any ‘sensitive’ data) click the “Print View” and copy and paste them to a text file, a Gist or to pastebin for me to checkout please.

Over the weekend I had to reinstall everything here locally (and my online servers for a different reason) as something was up with my database, I’ve created a topic here locally with ~10,000 replies today (similar in size to your second most popular topic) and it takes ~1.6 seconds to post a reply to this topic. To time the queries, install the following plugin and of course only have it activated whilst your debugging this stuff https://wordpress.org/plugins/query-monitor/

[Nitac]

Cheers for the response and thanks for your time and effort looking into this, much appreciated.

For the test below i set up a hidden forum on my live server.

What happens when you deactivate either/or “Go to first unread” & “Unread posts” plugins you’re using and submit a reply to an affected topic?

• I just went through all the bbpress related plugins and tried different combos and didn’t notice any significant performance differences.

Another test, this time with the ‘Quotes’ plugin disabled submit a reply to an affected topic.

• Using GDPress and had the same results as above

Another, what code and/or plugin are you using to show the user registration in each reply e.g. Join Date: Mar 2009
And another, what code and/or plugin are you using for the counts shown next to the username in each reply e.g Posts: 4529

• Using the function below. Again I disabled and noticed no significant improvement.

function func() {

$roleData = bbp_get_user_role(bbp_get_reply_author_id( $reply_id ));

if($roleData=='bbp_moderator'){
        $data='<div class="bbp-author-role">Moderator</div>';
}

$registered = date("M Y", strtotime(get_userdata(bbp_get_reply_author_id())->user_registered));

$post_count = bbp_get_user_reply_count_raw( bbp_get_reply_author_id( $reply_id )) ;

$data.='<div class="bbp-reply-ip"><span class="bbp-author-ip">';
$data.='Join Date: '.$registered;
$data.='<br />';
$data.='Posts: '.$post_count;
$data.='</span></div>';
}

Here’s the results for the first query

And the second query

Something I did notice when testing, was that when I was posting in the new topc I created, posts seemed to be submitting relatively quicker, 2 – 5 secs per post. Though when posting in a thread that had a lot more replies the post submission took a lot longer.

I tried the query plugin you suggested and getting relatively good results everything is < 2 secs, but it only shows the performance of the query results, and doesn’t take into account the time it takes to submit, which is > 10 secs. (unless I’m overlooking something??)

Thanks

[daniellajos.nl]

For our site, with 121 forums, +150k topics and +1.1m replies, it could take up 30s before something is posted. I traced it down to this query:

        //$voices = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT( DISTINCT post_author ) FROM {$wpdb->posts} WHERE ( post_parent = %d AND post_status = '%s' AND post_type = '%s' ) OR ( ID = %d AND post_type = '%s' );", $topic_id, bbp_get_public_status_id(), bbp_get_reply_post_type(), $topic_id, bbp_get_topic_post_type() ) );

includes/topics/functions.php, line 2610. It uses an OR clause, and MySQL (only in 5.1.73?) isn’t able to use an index anymore after a certain amount of records in the wp_posts table. I replaced the query with an UNION statement, and it executes much faster now, since it is using indexes again (as the EXPLAIN statements show me on a database with and without this amount of replies/topics):

        $unionQuery = "SELECT COUNT( DISTINCT post_author )
            FROM (
                SELECT post_author
                FROM {$wpdb->posts}
                WHERE post_parent = %d AND post_status = '%s' AND post_type = '%s'
              UNION
                SELECT post_author
                FROM {$wpdb->posts}
                WHERE ID = %d AND post_type = '%s'
              ) AS alias;";
    $voices = $wpdb->get_col( $wpdb->prepare( $unionQuery, $topic_id, bbp_get_public_status_id(), bbp_get_reply_post_type(), $topic_id, bbp_get_topic_post_type() ) );

[Robkk]

@daniellajosnl

thanks for sharing!!

@netweb

check that out.

[TriiXx]

Hi,

Sorry for up this old topic but i have the same issue.

I’ve migrate my Kunena forum to bbpress. It’s good but create topic and post answer are so sllllllow (juste post and create).

I’ve trie @daniellajosnl script but without success.

Thanks for your help

[senatorman]

Is there any solution for this slow post/reply problem.

I’ve the same problem and lose visitors

[senatorman]

bbPress speed (plugin not scalable?)