Notifications
Clear all

[Solved] How to configure the table engine for my wpForo database tables correctly?

4 Posts
2 Users
1 Likes
181 Views
stevenkwok
Posts: 15
Topic starter
(@stevenkwok)
Eminent Member
Joined: 2 months ago

Hi folk,

I'm trying to optimize my wpForo forum and just came across a previous post in this community: https://wpforo.com/community/faq/forum-is-slow/

Setting the table engine properly is a means to speed up the forum. While the post mentioned above discussed 17 tables, my current version has 20 tables (including one for the Prefixes addon). A screenshot is attached to this post for your reference.

In my case, how to set the table engine for them for better performance?

Thanks in advance,

Steven

wpForo Version
2.0.9
WordPress Version
6.0.2
3 Replies
Chris
Posts: 2405
Admin
(@chris)
Support Team
Joined: 1 year ago

@stevenkwok,

Set them all to InnoDB, but make sure that these two tables are set to MyISAM:

  • wp_wpforo_likes
  • wp_wpforo_visits
Reply
2 Replies
stevenkwok
(@stevenkwok)
Joined: 2 months ago

Eminent Member
Posts: 15

@chris Hi Chris,

Thanks for the info. But I cannot find the wp_wpforo_likes table in my database. Does the plugin save the like data into the wp_wpforo_activity table?

P.S. My current wpForo version is 2.0.9

Reply
Chris
Admin
(@chris)
Joined: 1 year ago

Support Team
Posts: 2405

@stevenkwok,

Sorry, the like table has been changed to reaction and it's better to let it InnoDB.

Reply