Stories
Slash Boxes
Comments

SoylentNews is people

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: 0) by Anonymous Coward on Wednesday January 09 2019, @03:06PM (2 children)

    by Anonymous Coward on Wednesday January 09 2019, @03:06PM (#784123)

    I knew it!

    This can't be the readDonaldTrump because he speaks far too clearly and makes too much sense!

  • (Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:22PM

    by Anonymous Coward on Wednesday January 09 2019, @11:22PM (#784332)

    It's just another clone.

  • (Score: 3, Interesting) by realDonaldTrump on Thursday January 10 2019, @11:23PM

    by realDonaldTrump (6614) on Thursday January 10 2019, @11:23PM (#784718) Homepage Journal

    I'm a professional at Technology. I'm like really smart.