MechBunny main page video order

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Matyko
    PsyHead
    • Aug 2005
    • 8681
    #1

    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
    Tags: None
    • k0nr4d
      Confirmed User
      • Aug 2006
      • 9231
      #2
      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

        Comment

        • Matyko
          PsyHead
          • Aug 2005
          • 8681
          #3
          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

            Comment

            • k0nr4d
              Confirmed User
              • Aug 2006
              • 9231
              #4
              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

                Comment

                • Matyko
                  PsyHead
                  • Aug 2005
                  • 8681
                  #5
                  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

                    Comment

                    • seeme
                      Stephen
                      • Jun 2011
                      • 840
                      #6
                      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...

                        Comment

                        • Matyko
                          PsyHead
                          • Aug 2005
                          • 8681
                          #7
                          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!
                          -=- Register with our ref link and we help you with the setup! -=-
                          AdSpyglass.com - Double your profit from brokers

                            Comment

                            • Screwed Up
                              Confirmed User
                              • Aug 2002
                              • 1120
                              #8
                              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.
                              Promote these REAL amateur sites with Exclusive content:

                              African Casting | Real Africans | Latina Fuck Tour | African Lesbians

                              African Bucks Contact: support @ africanbucks.com

                                Comment

                                • Matyko
                                  PsyHead
                                  • Aug 2005
                                  • 8681
                                  #9
                                  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

                                    Comment

                                    Previous template Next
                                    Working...