I have about 332,000 users, 160,000 posts, and about 32,000 topics. I migrated the data with a php program from a pre-existing custom forum.
The posts take about 10-15 secs to appear. My tables are all InnoDB. I have rebuilt the indexes. The wpforo caches are all enabled. I tried deleting and rebuilding the wpforo caches. I have no other plug-ins installed.
The Tools-》Debug shows no issues. I have Php 7.2, MySQL 5.7 installed. I do not have the Php mail () function hooked up.
I am using pure Http not Http.
Any idea what I might be missing?
Hi @bmurray161,
Please change the forum layouts to Simplified. The Extended layout gets 10 times more info to display the latest topics. As you have many forums we don't recommend use the extended layout. You should only change forum layouts for the Categories, you don't need to change forums, they'll inherits it from categories.
Also please make sure all table indexes exist. Navigate to Dashboard > Forums > Tools > Debug Tab > Tables sub-tab, copy the table list in some txt file and attach it here.
Sofy,
I am using the simplified layout.
I rebuilt the indexes as per your FAQ on slowness. But, when I can get to my computer, I will send the text file you asked for
When you submit a new post it sends email notifications to subscribers.If you have lots of subscribers to that forum and your hosting service email sender server is not fast enough the post submitting will take lots of time. So the 99% time is used for email sending process. So please make sure the PHP mail() function works fine and you don't have any extra Email configurations like SMTP or so. I din't understand what do you mean saying "I do not have the Php mail () function hooked up.". I just need to make sure the PHP mail() works fine. You can check it in the same Debug > Errors and Issues admin page.
Also, having 332,000 users makes your WordPress dozens time slower. I recommend remove all users who dont have comment, posts and forum topics. Whose Usergroup is not a special usergroup like customer or paid member. In other words I think the most of your user may be spammers and they make your side slow. If you remove spam registrations you'll have a few thousands of users or even less.
A website with such a large amount of users should be located in a very powerful dedicated server. Please let me know what kind of hosting service you use.
Robert,
We have a very large active user base. If 330K users is too many, what is the limit that wpforo can really handle?
We are using an AWS deducated RDS instance for the database.
I don't have the php mail () function actually hooked to any server functions. So, the mail () function is not actually functional. But, for our test forum, we also don't have anyone subscribing to anything either.
Robert,
We have a very large active user base. If 330K users is too many, what is the limit that wpforo can really handle?
We are using an AWS deducated RDS instance for the database.
I don't have the php mail () function actually hooked to any server functions. So, the mail () function is not actually functional. But, for our test forum, we also don't have anyone subscribing to anything either.
If the email function is disabled it makes more problem. Generating email sending errors takes dozens of times more time than sending emails. There maybe other plugin affection too. Also sometimes the problem is in redirection after submitting post. it does multiple redirection based on http/https wrong configuration.
It would be better if you install a fresh WP with wpForo in some sub-folder and test it.
