- 3 Posts
- 1.46K Comments
You really have to see what the db is doing to understand where the bottlenecks are, i.e. find the query plans. It’s ok if it’s just single selects. Look for stuff like table scans that shouldn’t happen. How many queries per second are there? Remember that SSD’s have been a common thing for maybe 10 years. Before that it was HDD’s everywhere, and people still ran systems with very high throughput. They had much less ram then than now too.
solrize@lemmy.worldto Technology@lemmy.world•Google's AI now listens to your English language phone conversationsEnglish132·2 months agoWTF. What could possibly go wrong. Flip phone here I come.
solrize@lemmy.worldto Technology@lemmy.world•Trakt to increase prices to $60 for all users, including those on legacy, promotional, and grandfathered pricingEnglish4·2 months agoOk I used to feel sorry for non-libre streaming software users, but this is now in “one born every minute” territory. Thanks.
solrize@lemmy.worldto Technology@lemmy.world•Trakt to increase prices to $60 for all users, including those on legacy, promotional, and grandfathered pricingEnglish194·2 months agoWhat the heck is this thing? Should many of us care?
I found the wikipedia article mostly incomprehensible but it says a few things. You are probably better off asking on MSE or Reddit, sorry to say. Wikipedia’s math reference desk has slowed down a lot in recent years though that’s possibly another place to try.
solrize@lemmy.worldto Ask Lemmy@lemmy.world•Alternatives to Skype for international calling?2·2 months agoAt least here in the US, lots of mobile phone plans have free or cheap international calls, depending on the countries involved. Example. Some home landline plans also have that. So far that has been enough for me on the few occasions when I’ve wanted to make an international call. If more frequent, I’d use a VOIP provider, maybe Twilio (I’m sure there are others too, but I know Twilio supports this and has a decent API).
VOIP providers will often also sell you inbound phone numbers in the destination country, if you want the other person to be able to call you from their landline without it getting rung up as an international call for them. Those aren’t always so cheap, but there are obvious use cases.
solrize@lemmy.worldto Selfhosted@lemmy.world•Using DVD slot for second 3.5" drive?English2·2 months agoOh I see. Yeah DVD drives generally use the same SATA interface as hard drives.
solrize@lemmy.worldto Selfhosted@lemmy.world•Using DVD slot for second 3.5" drive?English4·2 months agoIf you mean a 2.5" drive (laptop sized) then yes you can generally do that. 3.5" drives are usually 1" thick and won’t fit in a slim DVD drive slot.
solrize@lemmy.worldto News@lemmy.world•At least 10 people sickened in US listeria outbreak linked to prepared foods10·2 months agoArticle doesn’t say what kind of food. Bah.
solrize@lemmy.worldto World News@lemmy.world•10 YEARS OF HATE - Documentary about Orbán's politics of hate - English subtitlesEnglish1·2 months agoYeah I’m interested in the topic but am not up for watching an almost 2 hour documentary.
solrize@lemmy.worldto Ask Lemmy@lemmy.world•What's your plan for the Zombie Apocalypse?4·2 months agoHope they are vegan zombies.
solrize@lemmy.worldto Technology@lemmy.world•Disappointed in Plebbit : I Really Believed in the Vision, But It Was All Just TalkEnglish36·2 months agoSo, I’m sticking with Lemmy. It’s not perfect, but at least it’s real. Maybe we’ll get the true decentralization we’ve been promised one day
I thought we had Usenet since the 1970s.
Rep. Joe Morelle, the top Democrat on the House Administration Committee which oversees the Library of Congress and U.S. Copyright Office, is alleging it is “no coincidence [Trump] acted less than a day after [Perlmutter] refused to rubber-stamp Elon Musk’s efforts to mine troves of copyrighted works to train AI models.”
solrize@lemmy.worldto Ask Lemmy@lemmy.world•Is it fetishization for someone to find X ethnicity more attractive than every other ethnicity?1·2 months agodeleted by creator
solrize@lemmy.worldto No Stupid Questions@lemmy.world•Games on my PC start stuttering pretty badly when they aren't the active window for a while. Have to close the game and restart to resolve the stuttering issue. What exactly is causing this?4·2 months agoIf you have a hard drive, replace it with an SSD? And, can you add more memory?
solrize@lemmy.worldto News@lemmy.world•Is Russia co-opting US far-right groups to attack western democracies?92·2 months agoWho needs Russia for that? Is it because of the 4chan outage?
solrize@lemmy.worldto News@lemmy.world•Tesla driver charged in California attacks arrested again for road rage in Hawaii27·2 months agoBackground story from 2023. Multiple violent incidents and steroids and $30K cash were found in the guy’s car:
He was sentenced to 5 years in prison in CA but served less than 1, due to prison overcrowding. Apparently he was considered a nonviolent offender, wtf.
If they own houses that is public info.