Stories
Slash Boxes
Comments

SoylentNews is people

Meta

Meta: Late Christmas Present

posted by on Wednesday January 09 2019, @12:59PM   Printer-friendly
from the better-late-than-never dept.

The Mighty Buzzard writes:

While shutting down terminal windows to the SN servers this morning, one of them had the create table syntax for the comments table still on screen. I gave it a read through just because it was there and noticed that there wasn't an index for the opid (top level comment id for speeding up entire thread pulling) column. So I got some before numbers, added one, and ran some After tests. Heavily commented stories show a 50-150% pages-per-second speed increase in threaded views. Low hanging fruit FTW.

 
This discussion has been archived. No new comments can be posted.
Meta: Late Christmas Present | Log In/Create an Account | Top | 43 comments | Search Discussion
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

  • (Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:15AM (6 children)

    by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Thursday January 10 2019, @04:15AM (#784462) Homepage Journal

    I think I'll demand a raise from NCommander tomorrow. It's a new year and inflation's made my $0 worth around 2% less.

    --
    My rights don't end where your fear begins.
    Starting Score:    1  point
    Karma-Bonus Modifier   +1  
    Total Score:   2  

  • (Score: 3, Interesting) by realDonaldTrump on Friday January 11 2019, @11:55AM (5 children)

    by realDonaldTrump (6614) on Friday January 11 2019, @11:55AM (#784983) Homepage Journal

    So many of our best workers -- and my biggest supporters -- work, very proudly, for free. Thank you! #ShutdownStories [twitter.com]

    • (Score: 2) by The Mighty Buzzard on Friday January 11 2019, @12:23PM (4 children)

      by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Friday January 11 2019, @12:23PM (#784993) Homepage Journal

      I don't really work for free. I get paid in interesting news, well above average discussions about it to participate in, and dumbass comments about it to mock.

      --
      My rights don't end where your fear begins.

      • (Score: 2) by edIII on Friday January 11 2019, @11:36PM (3 children)

        by edIII (791) on Friday January 11 2019, @11:36PM (#785290)

        Well that won't do.... You should start a GoFundMe for good Whiskey. I'd pitch in to buy you a drink :)

        --
        Technically, lunchtime is at any moment. It's just a wave function.

        • (Score: 2) by The Mighty Buzzard on Saturday January 12 2019, @03:54AM (2 children)

          by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Saturday January 12 2019, @03:54AM (#785379) Homepage Journal

          Nah, I'd just embezzle it and blow it all on fishing gear. Better to avoid the temptation.

          --
          My rights don't end where your fear begins.

          • (Score: 2) by edIII on Saturday January 12 2019, @08:27AM (1 child)

            by edIII (791) on Saturday January 12 2019, @08:27AM (#785431)

            But I thought good Whiskey was included in fishing gear...

            --
            Technically, lunchtime is at any moment. It's just a wave function.

            • (Score: 2) by The Mighty Buzzard on Saturday January 12 2019, @11:34AM

              by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Saturday January 12 2019, @11:34AM (#785462) Homepage Journal

              Well, it can be but unlike beer it requires an additional hydration source and something sammich-like so you don't have to stop fishing. Whiskey's only part of your balanced breakfast not the whole thing.

              --
              My rights don't end where your fear begins.