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: 1, Interesting) by Anonymous Coward on Thursday January 10 2019, @03:12AM

    by Anonymous Coward on Thursday January 10 2019, @03:12AM (#784437)

    Just an FYI: The statement EXPLAIN QUERY PLAN isn't standard SQL, so the exact command differs depending on the exact implementation you are using. Sometimes it is EXPLAIN QUERY PLAN, EXPLAIN ANALYZE, or EXPLAIN VERBOSE, among some of the other options.

    Starting Score:    0  points
    Moderation   +1  
       Interesting=1, Total=1
    Extra 'Interesting' Modifier   0  

    Total Score:   1