Notifications
Clear all

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

4 Posts
2 Users
1 Reactions
562 Views
Posts: 15
Topic starter
(@stevenkwok)
Eminent Member
Joined: 2 years 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

3 Replies
Chris
Posts: 3650
(@chris)
Famed Member
Joined: 3 years ago

@stevenkwok,

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

  • wp_wpforo_likes
  • wp_wpforo_visits
2 Replies
(@stevenkwok)
Joined: 2 years 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

Chris
(@chris)
Joined: 3 years ago

Famed Member
Posts: 3650

@stevenkwok,

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