Forum loading really slowly

#1 · January 19, 2018, 4:22 am

I have two membership-based websites that use the Asgaros forum plugin for WP. It’s a great forum and it’s been working fine… until recently.

On one of my websites, which has a lot more activity, the forum as slowed down to the extent it’s becoming a real issue. Meanwhile, the same forum on my other website continues to perform as normal.

Is this a case of simply more users and more posts causing the database to slow down?

Is there anything I can instruct my hosting service to do regarding the database, to resolve this “slow” issue, as it is becoming a real problem.

Any advice welcome 🙂

#2 · January 19, 2018, 11:11 am

Hello mcjazz,

can you give me some stats about your community? How many posts, topics and users they have?

Its a little bit hard to reproduce this without direct access to your website. Can you please install the Query Monitor WordPress plugin on your website, activate the plugin and reload the related forum-page which is slow? There should be an on this page which shows you all slow database-queries. It would be nice if you could send me a screenshot of those which are listed there.

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#3 · January 19, 2018, 9:11 pm

Thanks for the prompt reply 🙂

The forum currently has 2,584 posts, 489 topics, 17,602 views and 130 users.

It’s always the initial forum page load and return to the main forum page that loads the slowest.

I have attached two screenshots here. The slowest one relates to initial load of the forum main page, or going back to the forum main page via breadcrumb link. The result shown is typical of around 90% of the loads, which can occasionally be faster.

The screenshot showing the faster/normal load relates to navigating around the forum once “inside” – like opening a topic or making a post for example.

Hope this helps.

Uploaded files:

#4 · January 19, 2018, 9:22 pm

Can you please for both views of your screenshot click on the orange part in the top area? There will appear a new menu with an entry called something like “Slow queries”. I need a screenshot of the exact queries which are listed there (e.g. “SELECT …”). If there is an entry with PHP-errors/warnings/notices a screen of its content would be helpful as well. 🙂

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#5 · January 19, 2018, 9:48 pm

Okay, here goes. Let me know if you need more.

Uploaded files:

#6 · January 19, 2018, 10:01 pm

Also this – “PHP Error”

Uploaded files:

#7 · January 20, 2018, 12:05 pm

The PHP-error is caused by another plugin so I cannot help with this.

Can you please check with a tool like phpMyAdmin if the following indices exist in the wp_forum_posts table?

Uploaded files:

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#8 · January 20, 2018, 9:40 pm

Here’s a screenshot of the page I believe you want to see.

Uploaded files:

#9 · January 20, 2018, 10:32 pm

The indexes are fine so far. This forum has a similar amount of topics and posts without any speed-problems. I also double-checked the query-speed on my development-environment and it seems fine. So its a little bit hard to reproduce this for me. There is also a possibility that this problem can be caused by a wrong database-configuration on your server (threads, caching, IO-times, etc) or the amount of other customers on it.

I will do some further tests the next days but I cant promise anything. If you want, you can send me a data-dump of the forum_posts and forum_topics tables so I could directly check it against this data to see if I encounter the same performance-problems on my development-installation.

If this is fine for you, you can send it to me via mail: developer(at)thomasbelser.net

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

#10 · January 21, 2018, 9:14 pm

Okay, will do. Thanks.