Part of the recent latency issues were caused by me grabbing the current user several times from the database unnecessarily on the path of every request for signed in users.
Don't feel bad. I recently worked on a website that would retrieve data exclusively from Redis. The problem was, whoever wrote the thought that Redis calls were free. It would make thousands of Redis calls in a single request... for the same data.
Lol redis is so good it’s always abused. Did you guys end up pipelining the requests?
… in this case I was grabbing the user 3 times, thinking that because it’s a primary key lookup it’d be fast, but it was ~30ms in some cases. Probably because Postgres’ cache is otherwise full or getting invalidated.
With subreddits, does the front page aggregate from subs as well, or does the front page stay for bitcoin-related? If it aggregates then I suppose the bitcoin needs to become a sub them. What would it be, /~bitcoin/ ?
Cool! Just hope we can have some more topics other than BTC.
personally I'd like r/investing or r/stocks, r/conspiracy r/technology r/programming r/linux, but also some esoterics like r/selfimprovement or r/meditation lol...
@k00b you should remove or find another way to distribute sats from jobs posting.
I know that some users are here just to "milk" those sats for "passive income" shit.
I am sure that wasn't your intention to create this precedent.
Definitely don’t want milkers. I’m going to be messing with the algorithms soon and hopefully I can figure out how to mostly reward generous users producing good content.
Reward also you those that are tipping more. Then create some kind of circular rebalancing.
I saw many that are tipping quite a lot here. I tip also but not so much as others.
Maybe you can come up with an algorithm.
What is the SN community's "bot defense" strategy? Can we detect or defend against the inflow of bots onto this platform as it gets more popular and lucrative?
Or should we welcome bots with open arms, value for value? May the best bot win?
There is a value in people learning how to use Tor... So maybe onion links should have a little question mark button in the detailed view that would explain what to do?
/r/science