Slow loading of EasyDiscuss sites
By Wojciech Gaweł on Friday, 15 May 2015
Posted in Technical Issues
Replies 7
Likes 0
Views 1K
Votes 0
Hi!

This is my first time, when I use stackidea's plugins.
I create a new version of portal. I try to migrate forum (with 95726 posts) from phpBB to EasyDiscuss. I create script to migrate topics, posts, users and polls from phpBB to Kunena. Then I use migration tool from EasyDiscuss (unfortunately, it ignored polls).
I have problem with performance of EasyDiscuss. Time of loading:
front-page: 6,5 s
topis: 4,3 s
topic: 1,3 s
categories: 0,7 s

In comparison, Kunena loads in 0,2-0,3 s.

My server configuration:
hardware:
Intel Core i7-3930K CPU @ 3.20GHz × 12
32 GB RAM
SSD

software:
Ubuntu 14.04
Apache 2.4,7
Percona 5.6.24

It is normal loading times? For me is not acceptable. What can I do to reduce it?

I enter all access data to dashboard.
Hi Wojciech Gaweł,

I am really sorry for the delay of this reply as it is a weekend for us here.

Perhaps you can try gzip compression suggestion and see how it goes?

Take a look of our blog : http://stackideas.com/blog/optimizing-the-delivery-of-javascripts-on-joomla

Keep us updated then.
Arlex Wong
·
Saturday, 16 May 2015 15:53
·
0 Likes
·
0 Votes
·
0 Comments
·
After gzip enable and add "AddOutputFilterByType DEFLATE (...)" line in .htaccess: Time of loading:
front-page: 3,3 s
topics (category view): 2,7 s
topic: 1,3-2,1 s
categories: 0,7 s

It is possible to achieve times less than 1 s?
---
Now, I found the problem (but not solution): sql queries, for example:
SELECT 

  a.*, 

  (

    SELECT COUNT(1)

    FROM `archlo_discuss_posts` AS p1

    WHERE p1.`user_id` = a.`id` AND p1.`parent_id` = 0 AND p1.`published` = 1

  ) AS `numPostCreated`, 

  (

    SELECT COUNT(1)

    FROM `archlo_discuss_posts` AS p2

    WHERE p2.`user_id` = a.`id` AND p2.`parent_id` != 0 AND p2.`published` = 1

  ) AS `numPostAnswered`

FROM `archlo_discuss_users` AS a

WHERE a.`id` IN (8356,8565,7824,8128,6965,3021,6666,8803,6930,7936,7762,8330,8809,8808,6154,8736)
take 2,7 s.
I enable mysql query cache. When I reload front page of EasyDiscuss that take 0,3-0,4 s. But when I click on topic, and then return to frontpage it take 3 s again. I understand that behaviour, mysql query cache is not solution. It is possible to optimize the sql query?
Wojciech Gaweł
·
Saturday, 16 May 2015 21:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I am really sorry for the delay of this reply as it is a weekend for us here. The frontpage discussions takes < 1s to render when I test this on your site and I think it's pretty good already.

However, to speed it up a little more, I have set the "Compile Stylesheet" to "Off" in EasyDiscuss settings so that the compiler doesn't go and try to look for changes on those .less files and compile them into css files. I can now seem to get around 500ms for the initial page load.
Mark
·
Sunday, 17 May 2015 17:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for your reply.
Frontpage discussions takes < 1s to render only when use mysql query cache. When I enter to two topics, and then return to front page it takes 3 s. Page load < 1 is only, when I refresh front page or topic - it is not the normal use of the forum.
Wojciech Gaweł
·
Monday, 18 May 2015 16:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Wojciech,

I've tried to view your site with the provided test case but seem like I'm not experiencing any slow loading issue. All page load approximately under 1s from my side. Perhaps if you want to reduce the loading time more you can turn off "Prune Notification on Page Load" from your backend > easydiscuss > settings > general > maintenance and enable the cronjob for your site.

You can also try to lower the down the frontpage/reply list from your backend > easydiscuss > settings > layout > general so that it will lower down the sql query.

Hope these help
Ezrul Fazwan
·
Monday, 18 May 2015 17:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Ezrul

Considering Optimizing Easydiscuss -
- Have set complie stylesheet to off as referred by Mr. Mark

Also - What would be the command of cronjob for Prune notification as cpanel wget, so that can turn off prune notification on page load
GM
·
Wednesday, 24 June 2015 21:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Gagan,

I am sorry for the delay of this reply.

You can refer to our documentation here regarding on the cron command for easydiscuss, http://stackideas.com/docs/easydiscuss/administrators/cronjobs/setting-up-cronjobs-in-cpanel
Ezrul Fazwan
·
Thursday, 25 June 2015 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post