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: 2, Funny) by Anonymous Coward on Friday January 11 2019, @03:40AM (1 child)
I saw something like that once. They got all the results from an unindexed flat-file database, looped through it looking for what they wanted. The worst part is that the loop didn't break once it was found, they just continued looping.
(Score: 2) by The Mighty Buzzard on Friday January 11 2019, @12:28PM
Could have been a religious imperative.
♫ Will the circle be unbroken / By and by, Lord, by and by / There's a better home a-waiting / In the sky, Lord, in the sky ♫
My rights don't end where your fear begins.