Hey guys!

Hope everyone’s well!

I’m starting to have some serious load time issues posting replies when a topic has more than a few subscribers.

I have an introduction topic for example.

When I post a reply now, it must take 10 seconds plus to actually be assigned a post number in the URL.

I actually receive the email notification quicker than the post actually bring pushed to the forum and appearing on the front end.

This is only going to grow exponentially.

I’m not a coder so this might be hard work, but is there any way we could get the reply to post THEN queue the emails?

What do you reckon JJ? Do you see this as an issue? Perhaps we could set individual topics to not allow subscribers also. Maybe an admin option?

Would love any suggestions!

Thanks!

Ross

[Stephen EdgarModerator @netweb 4 months, 1 week ago]

Can you create a ticket for this over in trac for this please: http://bbpress.trac.wordpress.org/
(Adding some ‘numbers’ would also help eg #subscribers & #posts so we can test this ourselves.)

[rossagrantParticipant @rossagrant 4 months, 1 week ago]

Done:

http://bbpress.trac.wordpress.org/ticket/2162

Thanks!

[rossagrantParticipant @rossagrant 4 months ago]

Could this also be anything to do with the way I have my DB set up by any chance? Is there any kind of optimisation that can be done to speed up MySQL queries here?

Thanks!

[rossagrantParticipant @rossagrant 3 days, 23 hours ago]

Just updated Trac.

Here’s my latest findings/ questions on this matter:

Hey JJ, just wanted to drop back in here.
I’ve duplicated my live site on a brand new dedicated server and the behaviour I was seeing on my shared server is still there.

I’ve been doing some tests with a server analyst from my host and his initial thoughts are that WP or BBPress, BP is waiting for a ‘true’ return on mail confirmation before it’s actually allowing any php to continue/ refresh the page to let the user see his post.

If I open up a new browser window and refresh the activity stream for example – AS THE OTHER WINDOW IS STILL PROCESSING THE POST – I can see that it has actually ALREADY been posted.
This means the post is being written to the DB pretty quickly and mail is starting to be sent with the topic reply subscription notifications, but it seems that the page can’t refresh for the poster until the mail has been sent and some kind of confirmation of that has been received.
It makes no difference whether I send the email locally or through SMTP (Google Apps), so it’s not the mail server being slow.

The topic that this is worst on still only has about 30 subscribers though, so it’s hardly hundreds or thousands.

I’m guessing that not many users even on BIG sites will get loads more than 30 or so for each topic, so this is why this may have gone unnoticed in the past.
Could you guys explain to me the process of what BBPress is actually going through BEFORE it is allowed to refresh the page the user who is posting is on.
Their post is being posted way before they get to see it – does the page wait for confirmation of the emails being sent.

There isn’t a problem posting new topics with no replies or very few voices.
I think it has to be something along these lines. Thanks!