Zen Mode

It is currently our zen mode where we get home to rest so that we can come back to work the next day and assist you with your issues.

Official support hours is from 10AM — 7PM Monday to Friday (GMT +8)

EasyDiscuss Performance - Issues And Suggestions
Resolved

We have a large forum (170,000 posts) which we have migrated from phpBB - we love the functionality of EasyDiscuss but have come up against some performance issues:

1. We are getting white pages every few hours caused by the Joomla cache running out of memory (over 130MB) - there are only a few hundred files in the cache and non-directly related to EasyDiscuss that I can see but the issue started when we installed EasyDiscuss. Clearing the cache allows the site to run again. Any insights you may have from other elarge EasyDiscuss installations would be gratefully received

2. You have a database query error in models/posts.php - you are using TIMEDIFF when the different can be over 838 hours. This throws a MYSQL error message. Instead of using the call like
TIMEDIFF(T1,T2)
you should use
TIMESTAMPDIFF(HOUR, T1, T2)


3. Your method getDiscussions generates a VERY slow query on our server - over 0.7 seconds. More than 0.2 seconds of this is to calculate last_user_anonymous - which is not needed on our site since we don't allow anonymous posting. Please add a check to the config before adding this sub-query

4. Your method getDiscussions also seems inefficient in linking in the post type data for some reason. This could easily be found using PHP and a lookup to a cached data call. When I remove the anonymous and post type parts of this query it takes 0.3 seconds instead of 0.7!!

Thanks

p.s. How do I change the domain for EasyDiscuss from our development server (ubu.jeventsclone.net) to the live server (www.jevents.net)?
4 replies

We are sorry, you need a valid subscription for EasyDiscuss
in order to view replies for this post in this category.

Your time
Stack Ideas time
Support is
Offline
It's after office hours

It is currently off working hours and most of us aren't around.

Rest assured that we will get back to your issues as soon as the day starts tomorrow!


Official support hour is:
Monday — Friday. 10:00 am - 7:00 pm
Our timezone:
Kuala Lumpur (GMT +8)