SoylentNews is people
SoylentNews
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.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
The mosquito is the state bird of New Jersey.
-- Andy Warhol
(Score: -1, Redundant) by Anonymous Coward on Wednesday January 09 2019, @05:22PM (8 children)
Glad you finally did your job!
(Score: 2) by pkrasimirov on Wednesday January 09 2019, @11:46PM (7 children)
Yeah, he finally earned his salary, right?
(Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:15AM (6 children)
I think I'll demand a raise from NCommander tomorrow. It's a new year and inflation's made my $0 worth around 2% less.
My rights don't end where your fear begins.
(Score: 3, Interesting) by realDonaldTrump on Friday January 11 2019, @11:55AM (5 children)
So many of our best workers -- and my biggest supporters -- work, very proudly, for free. Thank you! #ShutdownStories [twitter.com]
(Score: 2) by The Mighty Buzzard on Friday January 11 2019, @12:23PM (4 children)
I don't really work for free. I get paid in interesting news, well above average discussions about it to participate in, and dumbass comments about it to mock.
My rights don't end where your fear begins.
(Score: 2) by edIII on Friday January 11 2019, @11:36PM (3 children)
Well that won't do.... You should start a GoFundMe for good Whiskey. I'd pitch in to buy you a drink :)
Technically, lunchtime is at any moment. It's just a wave function.
(Score: 2) by The Mighty Buzzard on Saturday January 12 2019, @03:54AM (2 children)
Nah, I'd just embezzle it and blow it all on fishing gear. Better to avoid the temptation.
My rights don't end where your fear begins.
(Score: 2) by edIII on Saturday January 12 2019, @08:27AM (1 child)
But I thought good Whiskey was included in fishing gear...
Technically, lunchtime is at any moment. It's just a wave function.
(Score: 2) by The Mighty Buzzard on Saturday January 12 2019, @11:34AM
Well, it can be but unlike beer it requires an additional hydration source and something sammich-like so you don't have to stop fishing. Whiskey's only part of your balanced breakfast not the whole thing.
My rights don't end where your fear begins.