wpForo 1.x.x Posting is painfully slow
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?
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.
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.