Hello guys.

After some time developing with JomSocial we are facing troubles with performance. After a bit of looking around, we saw on the Debug Console a interesting information, the number of duplicated queries. Look at the example above:

Duplicate queries: #53 #57 #58 #61 #62 #65 #66 #69 #70 #73 #74 #77 #78 #81 #82 #85 #86 #89 #90 #97 #98 #101 #102 #114 #115 #118 #119 #131 #132 #282 #283 #286 #287 #290 #291 #294 #295 #298 #299 #302 #303 #306 #307 #312 #313 #316 #317 #320 #321 #326 #327 #330 #331 #334 #335 #338 #339 #342 #343 #352 #353 #356 #357 #360 #361 #364 #365
SELECT *
FROM `f8p71_community_likes`
WHERE `element`='comment'
AND `uid`=''

This query is repeated over and over again. The memory usage of the site is huge and it's breaking the app. Can you guys give some advice on how to optimize the app performance and use of the DB.

Thanks!

Hi, Steven.

Thank you for reporting this.
I assign developer to this thread.

Adding information:

This first profile is with the mod_community_members active.


Time: 10245.7 ms / 15300.1 ms Memory: 8.741 MB / 19.06 MB Application: beforeRenderModule mod_community_members (GPL Members)

Time: 0.2 ms / 20710.4 ms Memory: 0.005 MB / 20.39 MB Application: beforeRenderModule mod_community_whosonline (Whos Online)



This second one, the mod_commnunity_members is disabled.
Time: 25748.7 ms / 30649.1 ms Memory: 11.647 MB / 21.98 MB Application: beforeRenderModule mod_community_whosonline (Whos Online)

Look how different the performance is for the same module. What could be causing that?

Thanks.

Hello Steven

Can you unzip attached file and replace it in
ROOT/components/com_community/tables
Hope that helps

Cheers

Thank you Sinisa, but wasn't enough.

Part of the message is hidden for the guests. Please log in or register to see it.

After the login, the site keeps hanging for a while and than it loads veeery slowly.

To manage the website to work, since the dev.corephp.com doesn't, I've hacked a core file:
root/com_community/libraries/activities.php

From:
$html = $act->getHTML('', '', null, 0, $view, '', true, $showMore, null, false, 'all', 0, $filters);

To:
$html = $act->getHTML('', '', null, 1, $view, '', true, $showMore, null, false, 'all', 0, $filters);

My second entry here shows that on the first DB hit, JomSocial take ages to load. What else could be causing that strange DB behaviour?
Thanks!

Hey guys, any news or tips?

Thanks!

We are still more days out on this ticket. Can we get an answer on this.

Best,

Hello Steven

Sorry for late reply, but as a well known developer you should contact me directly to sinisa AT ijoomla DOT com and we could work this out pretty much fast

So, i went to your site, and i found out that the queries are actually not the issue. The problem at your site is your server that is generally configured bad and it losing a lot of time trying to do tasks that would otherwise take millisecond
As you can see on the picture bellow, your server is wasting a lot of time trying to return a simple responses

It takes crazy 10 seconds to just return 404. Thats not good at all, but this is hardly a JomSocial error.
Your other JomSocial unrelated pages on that side also takes on average 20-30 seconds to load.

This can be a sign of badly configured .htaccess, harsh settings of the server firewall, or even a misconfigured php handler.
Just for the sake of testing, try to disable all these modules on jomsocial pages
- GPL Members
- Videos
- Photos

these modules are trying to load thumbnails that do not exist on your server and hence the bad configuration of it requires a lot of time to deliver it.