By User on Wednesday, 03 March 2021
Posted in General Issues
Replies 4
Likes 0
Views 687
Votes 0
Hello. We noticed that "Leader Board module" and "Leader Board page" is very slow.

1) check page speed https://strana-krovi.com/community without Leader Board module (about 2 sec total)
2) publish in backend Leader Board module (it's allready created) in position es-dashboard-aside
Result: Page https://strana-krovi.com/community start to load a lot of seconds

3) check Leader Board page https://strana-krovi.com/leader
It loads very long time. Yes, it have a customization (to display active users for 30 latest days) in file
/components/com_easysocial/views/leaderboard/view.html.php
But if use original file, result is not better.

Thanks.


Also clients report there – there is a small error in file
/modules/mod_easysocial_leaderboard/tmpl/default.php

<div class=es-leader-context__info>
<?php echo $lib->html('html.user', $user);?>
<div class="mod-es-leader__points"><?php echo JText::sprintf('MOD_EASYSOCIAL_LEADERBOARD_USER_POINTS', $user->getPoints());?></div>
</div>


<div class=es-leader-context__info> no quotation marks for the class
Hi,

Regarding your issue with the leaderboard module and leaderboard page, I've added a db table index into `#__social_points_history` and this should increase the leaderboard module / page query performance.

Also, I've enabled your leaderboard module on your site so can you check again if the page still load very slow now?
Thanks.

Below is the sql that I've executed on your database:


alter table `#__social_points_history` add index `idx_created` (`created`);


Thanks and have a nice day
Sam
·
Friday, 12 March 2021 16:51
·
0 Likes
·
0 Votes
·
0 Comments
·
I will log into the issue tracker and see if we can optimize this because I noticed on your site this table `#__social_points_history` has more than 1 million records so caused this page load slow issue.

Also clients report there – there is a small error in file
/modules/mod_easysocial_leaderboard/tmpl/default.php


<div class=es-leader-context__info>
<?php echo $lib->html('html.user', $user);?>
<div class="mod-es-leader__points"><?php echo JText::sprintf('MOD_EASYSOCIAL_LEADERBOARD_USER_POINTS', $user->getPoints());?></div>
</div>



<div class=es-leader-context__info> no quotation marks for the class


Thanks for reported, I will log this into issue tracker as well.
·
Wednesday, 03 March 2021 16:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks. Users say it helped a lot. Leaderboard module and leaderboard page now loads faster
Should I execute this sql later (for example every 3/6 months)?
Thanks.
·
Friday, 12 March 2021 18:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Only execute one time enough.
·
Friday, 12 March 2021 18:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post