Stories
Slash Boxes
Comments

SoylentNews is people

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

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.
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: 3, Funny) by RandomFactor on Wednesday January 09 2019, @10:54PM (1 child)

    by RandomFactor (3682) Subscriber Badge on Wednesday January 09 2019, @10:54PM (#784320) Journal

    You.... You understood that.

    --
    В «Правде» нет известий, в «Известиях» нет правды
    Starting Score:    1  point
    Moderation   +1  
       Funny=1, Total=1
    Extra 'Funny' Modifier   0  
    Karma-Bonus Modifier   +1  

    Total Score:   3  
  • (Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:13AM

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

    His dumbassery ain't got nothin on some of the guys I grew up with.

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