MechBunny main page video order
 

Hi Fellow MechBunny users,

I am not really happy with the default method of listing the videos, and decided to go for random listing on main page. Prezzz helped me in finding a way to do this: ORDER BY RAND ... So I asked MojoHost to apply this on all my tubes, and they warned me that this can cause serious performance issues and I should find out something else besides this.

This made me reconsider what algo to use on the main page..

Is there anybody out there using non-default settings for this?

Thanks & Peace,

ORDER BY RAND() creates a temporary table in mysql so yes that would cause problems.

Most people if they don't like the sort order they change it to show newest first.

Konrad, that would cause problems on tubes with high traffic / tons of videos or on small niche tubes too?

Sorting by newest won't cause any problems. Sorting by RAND is more likely to cause problems on a bunch of small sites vs one big site since the homepage would be getting hit less frequently across a network and is likely to recache more often.

what if i do a cron job to randomize the date of the videos in db every x hours?

Add your own time field and order by that. Then add a bump button that updates that field to NOW(). That way you can just bump any video you want to front and is ordered this way...

Awesome idea, Thank You! :thumbsup :2 cents: :pimp

Sweet tip.

OK so the result is this: I do use 'ORDER BY RAND' but modded the site's cache so the pages are now cached for 300 seconds, this way I think there's no chance of problems.

This is not the very best solution, but does the job I want for next few months.