I mean water quality was a huge problem for the Paris olynpics.

I get a gig down but only 50mbps up (fucking spectrum), so I gotta limit seeding the same way or I’d just crush my upload speed all the time.

Storing large volumes of a text in a database column without optimization, then searching for small strings within it. It causes the database to basically search character by character to find a match by reading everything from disk. If you use indexes the database can do a lot of really incredible optimization to make finding values mich faster, and honestly string searching is better suited to a non-relational DB engine (which is why search engines don’t use relational DBs).

Cartesian explosion is where you join related data together in a way that causes your result set to be wayyyy bigger than you expect. For example if you try to search through blog posts, but then also decide to bring in comments to search, then bring in the authors of those comments and all their comments from other posts. Result sets start to grow exponentially in that way, so maybe if you only search a few thousand blog posts you might be searching through millions of records because you designed your queries poorly.

Substring searches in unindexed large string columns or cartesian explosion caused by shitty joins would be my initial guess.

Connect for Lemmy. Super under- rated.

We have porn! But yeah we need more population growth for niche and local communities to really flourish.

I think we should ultimately support algorithm feeds, but they should be free and open algorithms that can be peer reviewed, and also maybe give the users some control over which algorithm is applied and how. The problem with current social algorithms is they operate in the dark and are manipulative, not that they provide relevant content to users.

That’s a sweet icon pack

This is fucking hilarious. One of the most legitimataly funny XKCDs I’ve seen.

Oh shit yeah I forgot about that part. It’s been probably 10 or 15 years since I’ve seen it. I thought the panty raid and hidden cameras were bad, but damn, that movie did not age well.

I remember the first bit but not the rape?

They could mold each block, cast concrete into the mold, and use that as the base for the stones.

What was the service you could upload your own. Playlist and songs and share with friends? Last.fm? Something like that, shit was awesome.

I know of a SaaS company that charges for their products to end users for a monthly fee. They make significantly more money selling the data of their users to 3rd parties than they do from subscriptions. Also, they figured this out after the fact, it wasn’t a core business component when they launched, but they still ended up raising the monthly fees due to “inflation”.

How is no one in here talking about the International Fixed Calendar? It was exactly this, and Kodak used it for 60 years. It does work. https://en.m.wikipedia.org/wiki/International_Fixed_Calendar

Turok had you use the c buttons for movement and the stick to aim. It worked really well, and was functionally dual-analog too.

That was a heavy movie. But definitely worth a watch.

I’d say season 2 at least kept close to the original premise of being a mind fuck in the park (albeit many parks this time). It wasn’t as good as the original but I don’t think it’s as bad as the other guy says. After that though the whole tone changed so much in S3 that I didn’t even bother with S4.

Sportsurge dot net. Indexes every live sporting event, even pay per view fights and stuff.

Sportsurge dot net - indexer for pretty much any live sporting event. Then I use the webvideocaster app to cast it to a roku tv.