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.
Remember Darwin; building a better mousetrap merely results in smarter mice.
(Score: 2) by Kilo110 on Wednesday January 09 2019, @08:13PM (3 children)
Where's my bitcoin subscription option?
(Score: 2) by Kilo110 on Wednesday January 09 2019, @08:15PM (2 children)
I'm blind.
(Score: 2) by Kilo110 on Wednesday January 09 2019, @08:22PM (1 child)
I went to subscribe with bitcoin and it didn't work. So my original comment still stands.
(Score: 2) by The Mighty Buzzard on Thursday January 10 2019, @04:25AM
Stripe stopped supporting BTC around the time transaction fees became larger than a year's subscription here. Yes, we do need to remove the outdated info though.
As for a new cryptocoin option, I'm a bit sick of dealing with trendy, short attention span assholes who think it's okay to have a non-versioned API and break backwards compatibility a couple times a year when you're dealing with people's money. If anyone wants to write up a plugin for their favorite "you pay in cryptocoins, SN gets cash money" service, I'll code review it and merge it. Hell, I'll even help if you need it. I'm not going to code any more modules to use an API that's not going to work in six months though.
My rights don't end where your fear begins.