Hi Dmitry,

Regarding the random sorting in videos, we've changed the behaviour to simulate the 'randomness' by randomly pick a column from the video table and sort based on that particular column. This applied to the ordering as well where it sometime sort based on ascending order and sometime based on descending orders.

The reason we've implement the above is that in previous random order, we use this 'order by rand()' from MySQL but this rand() gave a great impact to the performance and thats is why we have to use the alternatives.

Hope this clarify the new behaviour of order by random.

Hello. Can you please discuss this suggestion.
I beleave it will allow to display really random items.
(not 100% all from all time; but latest, created by XX days).
Thanks.

Hi Dmitry,

To be frank with you, I don't see how 'trending' can produce 'randomness' of the videos in term of video sorting. Anyway, I do appreciate your idea of displaying the videos that created from xx days so that old popular videos will not always stay on the top of the listing.

As I've mention in my previous reply, currently there is no real way of display video in random unless you can sacrifice the performance by using the 'order by rand()'. If you do, then you can edit this file 'JOOMLA/administrator/components/com_easysocial/models/videos.php'

and replace below code at line 928:

$query[] = "order by $rndColumn $rndSort";

to:

$query[] = "order by rand()";

Hope this help and have a nice day