MechBunny main page video order - GoFuckYourself.com

Matyko · 05-24-2012, 04:07 AM

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,

k0nr4d · 05-24-2012, 04:13 AM

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.

Matyko · 05-24-2012, 04:22 AM

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

k0nr4d · 05-24-2012, 04:35 AM

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.

Matyko · 05-24-2012, 04:49 AM

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

seeme · 05-24-2012, 07:21 AM

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...

Matyko · 05-24-2012, 07:28 AM

Quote:

Originally Posted by addyourcontent

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!

Screwed Up · 05-24-2012, 08:35 AM

Quote:

Originally Posted by addyourcontent

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...

Sweet tip.

Matyko · 05-25-2012, 01:05 AM

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.

05-24-2012, 04:07 AM	#1
Matyko PsyHead Industry Role: Join Date: Aug 2005 Location: Hungary Posts: 8,666	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, __________________ -=- Register with our ref link and we help you with the setup! -=- AdSpyglass.com - Double your profit from brokers

05-24-2012, 04:13 AM	#2
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	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. __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development

05-24-2012, 04:22 AM	#3
Matyko PsyHead Industry Role: Join Date: Aug 2005 Location: Hungary Posts: 8,666	Konrad, that would cause problems on tubes with high traffic / tons of videos or on small niche tubes too? __________________ -=- Register with our ref link and we help you with the setup! -=- AdSpyglass.com - Double your profit from brokers

05-24-2012, 04:35 AM	#4
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	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. __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development

05-24-2012, 04:49 AM	#5
Matyko PsyHead Industry Role: Join Date: Aug 2005 Location: Hungary Posts: 8,666	what if i do a cron job to randomize the date of the videos in db every x hours? __________________ -=- Register with our ref link and we help you with the setup! -=- AdSpyglass.com - Double your profit from brokers

05-24-2012, 07:21 AM	#6
seeme Stephen Industry Role: Join Date: Jun 2011 Location: Europe Posts: 840	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...

05-25-2012, 01:05 AM	#9
Matyko PsyHead Industry Role: Join Date: Aug 2005 Location: Hungary Posts: 8,666	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. __________________ -=- Register with our ref link and we help you with the setup! -=- AdSpyglass.com - Double your profit from brokers