Tvshowsondvd.com question

Discussion in 'DVD' started by Brad Martin, May 22, 2003.

  1. Brad Martin

    Brad Martin Extra

    Joined:
    Dec 10, 2002
    Messages:
    17
    Likes Received:
    0
    Does anyone know if there is a way to look at the order of the most requested shows? I know that they list the top 10 on the frontpage and that if you request a show it shows you the number of votes and where it is ranked on the list. I'm curious because I see that Beverly Hills 90210 is currently at #22 and I was wondering what shows are ahead of it (besides the top 10). Any help of information would be great. Thanks alot!
     
  2. David Lambert

    David Lambert Executive Producer

    Joined:
    Aug 3, 2001
    Messages:
    11,380
    Likes Received:
    38
    I'll pass this question on to Gord, the site owner.
     
  3. Gord Lacey

    Gord Lacey Cinematographer

    Joined:
    Jan 3, 2001
    Messages:
    2,442
    Likes Received:
    28
    Hey Brad,

    We only list the top 10 shows for a variety of reasons, but mainly because of the database query that is going on. At one point I had another page that was loading more shows but the query was taking longer than it should. If I can find the time I'll look at optimizing the query, but for now it's just the top 10 shows.

    Gord
     
  4. Chris Beveridge

    Chris Beveridge Second Unit

    Joined:
    Jul 3, 1998
    Messages:
    349
    Likes Received:
    0
    Gord,

    We had similar issues, but what we opted to do was to have it run "on demand" by myself and generate a static html page. It's actually quite useful for a lot of pages with a database driven site, since the bulk of pages just don't get updated all that often.
     
  5. Andy_MT

    Andy_MT Second Unit

    Joined:
    Jun 23, 2001
    Messages:
    486
    Likes Received:
    0
    Gord; Chris is right, better to cache the page (top X shows) than to continually re-run the query. simple to do as well; run the query for top X shows (say, once every week), save the generated HTML page, then post this HTML file on your site. it'll tide you over until you can optimise the query or come up with a better solution.

    as an afterthought, you could run your query every X hours (as a scheduled task), store the results in a new table in the database and have your "top X" shows page get it's data from this new table. this way, no need for manual intervention. i'm just rambling now.
     
  6. Adam Tyner

    Adam Tyner Screenwriter

    Joined:
    Sep 29, 2000
    Messages:
    1,410
    Likes Received:
    0
    Yeah, a summary table that's generated every so often would probably be the way to go.
     
  7. Brad Martin

    Brad Martin Extra

    Joined:
    Dec 10, 2002
    Messages:
    17
    Likes Received:
    0
    Gord,
    Thanks for the explanation. Maybe there's a way to do a "biggest gainers" at the end/beginning of each month. Like the five or ten shows that moved up the chart or something. I love the site, thanks for all you do with it. Just something I personally would love to see. Thanks again.
     
  8. Gord Lacey

    Gord Lacey Cinematographer

    Joined:
    Jan 3, 2001
    Messages:
    2,442
    Likes Received:
    28
    Yeah, I'm going to have to look at something for the query. There's so much traffic to the site (40+ gigs of text/graphics a month now!) that things are going a bit crazy on the server. I changed some stuff around on the weekend and it's running slightly faster now.

    Thanks for the suggestions,
    Gord
     

Share This Page