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.

😂

Prove right now that you’re not a shill for Big Lemmy!

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.

Also easy to repair. I got one that’s like 8 years old and I replaced the blower and a sensor and its super easy and the components are cheap.

Yeah I’m a 20-some year FF user and when it started you had to have IE as a backup because not everything was compatible. In the late 2000s through late 2010s everything worked everywhere, then with chromes dominance places have stopped testing or supporting certain things in FF and it feels like history is repeating itself. Unfortunately you need a chromium-based backup realistically for certain sites, but 99.5% of things work totally fine in FF.

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.

Homie was from Ohio too. Wouldn’t even half ti march halfway across the country.

It depends on how you define “the USA”. If you mean the people of this country, then absolutely they are working against us. If you mean the people with loads and loads of money, then no, they are working as hard as they fucking can for them.

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

Sam probably still controls a ton of shares, so I think effectively this would give them >50% of shares as long as they are partnering.