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.
(Score: 3, Funny) by RandomFactor on Wednesday January 09 2019, @10:54PM (1 child)
You.... You understood that.
В «Правде» нет известий, в «Известиях» нет правды
(Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:13AM
His dumbassery ain't got nothin on some of the guys I grew up with.
My rights don't end where your fear begins.