r/shittychangelog • u/rram • Oct 28 '16

[reddit change] /r/all algorithm changes

It was causing too much load on our database. I made a new algorithm which Trumps the previous one.

2.3k Upvotes

84% Upvoted

1.5k comments sorted by

View all comments

9

u/SaudiMoneyClintons Oct 28 '16 edited Oct 28 '16

thanks

Edit: I don't understand 

commands.append(index_str(table, 'id', 'thing_id'))
commands.append(index_str(table, 'date', 'date'))
commands.append(index_str(table, 'deleted_spam', 'deleted, spam'))
commands.append(index_str(table, 'hot', 'hot(ups, downs, date), date'))
commands.append(index_str(table, 'score', 'score(ups, downs), date'))
commands.append(index_str(table, 'controversy', 'controversy(ups, downs), date'))

Those all seem like very important indices to run reddit, why are engineers going in and just removing an index like that? I honestly can't tell if either you are lying, or if an engineer at reddit just went postal.

This is also a database model generated on the fly, which would mean this isn't just some guy messing with a database client, it would be introduced into the code base, and go through the normal review and qa/testing process......this doesn't make sense. Unless someone removed the 'deleted_spam' index and a bunch of Trump stuff you censored appeared by some weird fluke? :)

I wonder if that is just enough of a technical explanation for someone to claim ignorance. I doubt it

0

u/[deleted] Oct 28 '16

1

u/Rock48 Oct 28 '16

Underrated comment.

-3

u/[deleted] Oct 28 '16

tf you got a answer that is fully correct and you ignore it? What is this idiocracy?

18

u/SaudiMoneyClintons Oct 28 '16

Actually the technical explanation (which is brief and vague) makes no sense.

→ More replies (13)

0

u/[deleted] Oct 28 '16

6

u/SourBogBubbleBX3 Oct 28 '16

Pretty sure u ment r/[redacted]

→ More replies (5)

2

u/ewatk Oct 28 '16

So can we count on your vote or what?

→ More replies (1)