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) by zocalo on Wednesday January 09 2019, @02:12PM (7 children)
OK, I know there have been a few, but it's still pretty rare, but well done on spotting the missing index and taking the time to investigate further anyway. Faster load times = more time to read and comment!
UNIX? They're not even circumcised! Savages!
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @02:33PM (6 children)
Ten in the last thirty days. Two of them journal entries. That's not bad for us for a month heavy on holiday stuff.
My rights don't end where your fear begins.
(Score: 5, Funny) by Runaway1956 on Wednesday January 09 2019, @02:55PM (5 children)
I told you I'd be back to help you finish off the ham, and all those pies. But, did you listen? Noooooooooooo - you ate it all yourself. Now you're gonna complain about heavy? I don't wanna hear it. No sympathy from me that you have to turn sideways to get through the door.
(Score: 3, Touché) by The Mighty Buzzard on Wednesday January 09 2019, @03:11PM (4 children)
Man, I only put on five pounds between the big food holidays and having to eat more often for ten days of thrice-a-day antibiotics. Since I lost 35 pounds or so over the past year, I'm calling that a win.
My rights don't end where your fear begins.
(Score: 2) by Runaway1956 on Wednesday January 09 2019, @04:50PM (3 children)
Ugghhhh - hate those meds. And, they suck even more during the holiday season.
(Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:09AM (2 children)
First time I've taken any since my 20s. They're just as annoying now as then. And the dipshit PA felt the need to prescribe me not one but two bloody decongestants after I told him the infection had my sinuses the clearest they had been in decades.
My rights don't end where your fear begins.
(Score: 2) by Runaway1956 on Thursday January 10 2019, @02:35PM (1 child)
Sinuses? Try scuba diving. They gave me hell through my teens. Guess I was 20, almost 21 when I took my diving lessons. We got out of the kiddy pool, and went on our first real dive, diddling around at around fifty feet. My ears popped, and I started running at the nose, head felt weird, and I headed to the surface. I was a god-awful mess for a couple hours, but I've never had sinus problems like I did in my teens. I suppose if I had ever described the experience to a nose-throat-and-ear specialist, he could have explained it. All I know is, life changed when I took up diving.
(Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @05:13PM
Allergies have kept mine half plugged since my late teens. The sinus infection had them almost entirely clear. Weirdness doth abound in my general vicinity.
My rights don't end where your fear begins.