Main forum page loading slowly

#1 · February 19, 2018, 12:45 am

Hello, I wanted to start off by saying I really love this forum software, the best I’ve come across for Wordpress. I’ve loved using it, but have recently been having a small problem with the forum, which is the main page has been loading very slowly. I don’t have a very populated site, only 27 users, just over 200 topics, and about 1100 total posts, but when I visit the forum page it takes a very long time, sometimes 25-30 seconds, for the forum to load. When I click on any board or any topic, it’s very quick to load, almost instantaneous, it is only the main page that has any slowness.

I tried disabling many features to speed up the forum, including Show who is online, show statistics, member list, and enable search functionality, but none of them have sped things up in the slightest. Any help you could give would be greatly appreciated.

#2 · February 20, 2018, 6:46 pm

Hello @drenaud

I assume that this could be a configuration-problem with your database. Can you please install the following WordPress plugin? While visiting the forum-overview there should be some area showing slow queries. Can you make a screenshot of this section?

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

#3 · February 20, 2018, 8:47 pm

Yes of course, I did as you asked and think I can see the problem now. When I looked at the query monitor, it showed 18 slow queries, one from a slider plugin taking .2 seconds, and 17 from asgaros, which all seemed to be the same query, just running multiple times. Each one was taking up about 1.7 seconds, and looking at it, it looks like it’s running the query to see which posts are new since the user has last visited, and so it has to run once for each board on the forum.

I’m attaching the screenshot as you asked, is there some sort of configuration I can change with my database to make this run more quickly?

Uploaded files:

#4 · February 22, 2018, 12:30 pm

Can you check with a tool like phpMyAdmin if the following index-entries exist:

Uploaded files:

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

#5 · February 22, 2018, 6:39 pm

Yes, it looks as though I do have those indexes on the forum_posts table.

Uploaded files:

#6 · February 23, 2018, 10:54 am

Mh, this is really strange. So all settings seem to be fine. What I dont understand is: This problem happens to you and you dont even have as many topics/posts as in this forum. And here everything is running fast. Can you press the “mark all read”-link in the overview once and check if its running faster after it?

If this does not help it could be a general configuration/performance problem of your database (or a bad database-server configuration of your webhoster).

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

#7 · March 21, 2018, 7:58 pm

I am experiencing the same issue 🙁 . The strange thing that is only with Safari 😐