don't click here

Don't read the front page? You suck.

Discussion in 'Announcements' started by Scarred Sun, Aug 19, 2012.

  1. Andlabs

    Andlabs

    「いっきまーす」 Wiki Sysop
    2,175
    1
    0
    Writing my own MD/Genesis sound driver :D
    And finally, all the speed issues have been sorted out. The front page has gone from a max of 9 seconds several months ago to at most 650 milliseconds to load. Everything now runs nicely under a second, even the front page! No need for caching; this is still in real time. Now let's get this show on the road!



    For those who wonder: when I was grabbing the list of scanboxes and whether or not files were good or not, I was making one query per game/file (respectively). This meant lots and lots of database hits, which was making everything slow. I got rid of the scanbox mess a while ago (with Metal_Man88's help), but had kept the one query per file check until now. Lesson: don't hit the database too often. There are two issues here, but they are both irrelevant for now (and hopefully forever). The first issue is that this may mean the server is going to eat up memory (but I have a garbage collector which I hope will come in when the page has fully rendered and all the reference to everything are dropped) and have string operations all over the place, but 650ms max for the front page shows me this isn't a problem. The second issue is that because all information is transferred on all pages, even individual console pages, the individual console pages are going to take slightly longer to load because they pull in data they do not use. However, again, this is a negligible change (~100ms or so, I think).
     
  2. SeanieB

    SeanieB

    Chief Server Monkey Administrator
    457
    38
    28
    San Diego, CA
    Fixing Sonic Retro
    I've also been doing a ton of server-side optimizations, I think I've basically done all I can with all the existing systems. But I think I made out pretty well. I'm probably just gonna be doing mostly maintenance at this point, everything else would come out in the form of replacing the forum software or transitioning the DB engine type, and a few other things I just don't really want to go near on my own. (like updating the Retro wiki)
     
  3. Metal Man88

    Metal Man88

    Time Traveller Oldbie
    2,137
    0
    0
    Ah, I've been wanting to see the database stuff in action for a while now. Happy to see the idea I had worked.
     
  4. Out of curiosity, how long has it been since the NTSC Genesis list was updated? My friend has a bunch of cartridges that we might need from that list, but I don't know if we already have them.
     
  5. Mastered Realm

    Mastered Realm

    Member
    3,828
    553
    93
    -
    When will the Marble thing go to the front page?
     
  6. Andlabs

    Andlabs

    「いっきまーす」 Wiki Sysop
    2,175
    1
    0
    Writing my own MD/Genesis sound driver :D
    I don't know, but an always-up-to-date list can be found at http://andlabs.sonicretro.org/scans/Mega%20Drive%20games?region=US in the Media column (this updates in real time too)
     
  7. MathUser

    MathUser

    3rd top wiki contributor Researcher
    2,151
    8
    18
    I thought the marble thing would have been good on the front page too. But I guess it's not considered a major discovery.