DearDiary Logo
Public DiariesHomeLogin

Top Ten Diaries Offline
Fri May 07 2004

The Top Ten Diaries is offline presently because the query (amongst a couple of others) was killing the system. It needs redesigning to be more MySQL friendly (which is bizarre, but MySQL really chugs on some queries on the entries tables now)

I think ADM jokingly said in one of his entries - maybe there are too many diaries on the system - in a way its true, the problem is that the entries table has become so huge that any query that joins to it really needs to be seriously optimized otherwise it goes nuts. Anyway, we're getting there

Steve

9 Comments
  • From:
    Allimom (Legacy)
    On:
    Fri May 07 2004
    How would it affect the system if the voting option was put back in, and the top ten was a result of votes rather than the query that is currently running?
    Alli
  • From:
    JustAnotherBeth (Legacy)
    On:
    Fri May 07 2004
    What's the Top Ten List?
  • From:
    Eliezer (Legacy)
    On:
    Fri May 07 2004
    Are we overdue for another IT chat? :-)

    Give me a large enough DB schema and I'll move the world!

    Eliezer
    IT Data Warehousing Dude
    "Queries are my business"
  • From:
    JanuaryGirl (Legacy)
    On:
    Fri May 07 2004
    Uh..... Yeah.. What Steve said.. You go, boy-yeeeeee.. I'll pretend that I understand and smile and nod. Just be over here, cheering for you from the sidelines..
  • From:
    Lightmiracle (Legacy)
    On:
    Fri May 07 2004
    A few administrative headaches could be avoided by getting rid of the Top Ten Diaries altogether.

    You could replace it with a highly visible link to, perhaps, the Hot Topic for the Day in the forums.
  • From:
    Lightmiracle (Legacy)
    On:
    Fri May 07 2004
    Get rid of the front page LINKS to the diaries, not the diaries themselves, I meant.
  • From:
    AeolianSolo (Legacy)
    On:
    Fri May 07 2004
    I second Lightmiracle. Do we need a popularity contest? I rarely look at the Top Ten diaries anyway, since I read only English and a little French, and half of them are in languages I can't even identify (yes, I know; I'm so American!). Anyway, I think it's a feature I wouldn't miss.

    How about a slightly longer list of "just updated" entries instead?

    --Solo
  • From:
    AeolianSolo (Legacy)
    On:
    Fri May 07 2004
    I second Lightmiracle. Do we need a popularity contest? I rarely look at the Top Ten diaries anyway, since I read only English and a little French, and half of them are in languages I can't even identify (yes, I know; I'm so American!). Anyway, I think it's a feature I wouldn't miss.

    How about a slightly longer list of "just updated" entries instead?

    --Solo
  • From:
    Lightmiracle (Legacy)
    On:
    Sat May 08 2004
    LOL. You sure DID second me Aeoliansolo. ;)