Hello,
I visited the link you sent and I am on the Table Engines section.
First of all the image in the link shows the database entries as
- wp_wpforo_forums
- wp_wpforo_posts
- wp_wpforo_topics
- wp_wpforo_profiles
- wp_wpforo_views
On my database these show as:
kqd_wpforo_forums
kqd_wpforo_topics
kqd_wpforo_views
etc
Is that okay?
Secondly there are two database entries that are not present in your image or my table i.e. wp_wpforo_views and wp_wpforo_likes.
Is this an issue?
Anyways I just had to change one entry i.e. kqd_wpforo_visits to MyISAM while the rest were all as recommended.
Also on the wpforo cache section, there are several options that you said need to be turned on such as
- Enable Member Cache
- Enable Object Cache
- Enable Memory Cache
However there is only one cache option in wpforo i.e. enable cache and that is already turned on.
All my forums and subforums are on simplified layout as you suggested and there is no loopback issue as well. I always had my community forum (wpforo) on my cache plugin's exclusions as well. I am not sure if making that MyISAM change will be enough to make a speed change.
Hi,
We recommend change the following tables to InnoDB (please backup all tables before this manipulation):
As already mentioned in the FAQ, all tables should use the InnoDB engine. Please update all tables to InnoDB and check again.
Hello,
There is some confusion. On the FAQS it is written that:
We recommend change the following 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
And make sure the following tables Engines are still MyISAM:
-
wp_wpforo_likes
-
wp_wpforo_visits
So should I do the above (which I already have) or change ALL of them to InnoDB including wp_wpforo_likes and wp_wpforo_visists
I agree with this and have brought it up before a couple of times. Wpforo IS slow. It's not always slow to browse and for some reason editing posts is ultra fast, but actually posting is super slow. I am yet to see a single wpforo forum that is fast when posting. Not this one, not any. In fact, my forum is even faster to post than this one.
I think there is some optimization to do here and probably the biggest downside of wpforo that I can think of.