[Closed] If forum is slow  

wpForo is designed to be very fast and work with small and large databases. However there are many factors which may slow wpForo. Please follow to these instruction:

1.Forum Layout

If you have large number of forums and subForums we recommend Simplified Forum layout.

2.Table Engines

wpForo tries to create InnoDB database tables on installation, but sometimes it's not allowed or the database is migrated from other server and tables become MyISAM. We recommend change these tables to InnoDB (please backup all tables before this manipulation):

• wp_wpforo_forums
• wp_wpforo_posts
• wp_wpforo_topics
• wp_wpforo_profiles
• wp_wpforo_views

Here an instruction How to change the database engine of a MySQL database table.

3. Indexes

The second Important change in database is the table indexes. Using the same Hosting cPanel > phpMyAdmin > WP Database > SQL Tab you should execute these SQLs to built table indexes. Insert the SQL mentioned below to the SQL query textarea. If your WordPress table prefix is not wp_   replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:

ALTER TABLE `wp_wpforo_posts` ADD INDEX(`topicid`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`forumid`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`userid`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`created`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`is_answer`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`is_first_post`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`status`);
ALTER TABLE `wp_wpforo_posts` ADD INDEX(`email`);

ALTER TABLE `wp_wpforo_topics` ADD INDEX(`forumid`);
ALTER TABLE `wp_wpforo_topics` ADD INDEX(`first_postid`);
ALTER TABLE `wp_wpforo_topics` ADD INDEX(`created`);
ALTER TABLE `wp_wpforo_topics` ADD INDEX(`modified`);
ALTER TABLE `wp_wpforo_topics` ADD INDEX(`type`);

ALTER TABLE `wp_wpforo_forums` ADD INDEX(`is_cat`);
ALTER TABLE `wp_wpforo_forums` ADD INDEX(`order`);
ALTER TABLE `wp_wpforo_forums` ADD INDEX(`status`);
ALTER TABLE `wp_wpforo_forums` ADD INDEX(`parentid`);

Please note: If you install a fresh wpForo 1.4.0 or higher, it creates all indexes. You don't need to run these queries again.

4. wpForo Cache

Please make sure all caches are enabled in Dashboard > Forums > Settings > Features admin page:

If you have other cache plugins, we recommend disable other caches for wpForo pages. All cache plugins should have an option to disable caching for certain page. The main wpForo page is the one which contains [wpforo] shortcode. In most case it's example.com/community/ . You should disable other cache plugins for example.com/community/* .