select stuff from pending_downloads left outer join a ton of stuff; no wait...
select host,COUNT(*) from pending_downloads etc... group by host order by requested then add the hosts to a may I use host plz request, then send the request. Then get a reply with NxM hosts I can use. and THEN select stuff from pending_downloads left outer join a ton of stuff except only those hosts somehow wait shit; uhh...
create temporary table those_hosts_somehow (derphost TEXT); insert into those_hosts_somehow etc...; and THEN
select stuff from pending_downloads INNER JOIN those_hosts_somehow ON derphost = host left outer join a ton of stuff
how is this so complicated... I just want to download stuff from a bunch of hosts, and not do more than like 3 downloads per host at a time. #fml
desperately trying to persuade my daughter to want to get her hair cut (time issues, plus it’s impossible to get it to stay tied up for longer than half an hour…) and she tells me tonight,
“I want to be like that princess with no shoes and the purple dress!”
i.e. Rapunzel, the princess with literally the longest hair a princess has ever had 🫠 #fml
OK so for each database row I check if the IP address is being used too much. If it is, I skip the row. If not I'm considered a user of that address, and can process the row. Every "processing" should eliminate the row it comes from in future queries, so the next time I search, once something is finished, the skipped rows will come up again. I can't LIMIT the query though, since I don't know how many rows will be skipped.
And to check how much an address is in use is a network round trip, so I queue up addresses to query for that, and batch send the queries, to get a reply for how many times I can use that address. So first I go through all rows to see what addresses are needed, then send that address-use query. Once I get a reply, I go through all the rows again to see which I can get rid of based on that reply, until I've started enough parallel requests to different addresses.
Except I can't predict how many rows I can get rid of in the second query, so the first query has to iterate over every single database row every time just in case. Not only can it not have a LIMIT, I can't stop queueing up address-use requests until the first query stops returning rows.
But... this query is in theory... not a lot of rows. It's just supposed to search for database records with holes, missing fields that could only be gotten by requesting a specific webpage from a given address. In theory that could mean 7 million user profiles who all failed to load properly because I tried to view them before downloading the avatar image and profile page, but when am I going to look at 7 million profiles at once? It should be like, 10 profiles per page or something, and the address-use query is over the local network so it should happen faster than I can click the "next" button to add on 10 more rows. But I can't guarantee that. Ugh...
Do you care if someone at work doesn't seem to like you?
I don't have enemies, but there's been a couple of people who I can't connect with. But in our job it doesn't really matter, so I don't worry too much.
I wonder if we're just at the same level of social skills, so we're at a stalemate
Long story short: I’ve updated the pwd on my keychain by mistake. Then couldn’t get into #FinalFantasyXIV. Password reset doesn’t work, I gotta wait until Monday when SE support is back online #fml
Update: We pushed his trip back a few hours, but now we're being made to feel like this was our fault when it was originally agreed that he'd pay for his own Ubers and stuff, especially when we told him we didn't have much money to begin with.
If anyone can please assist with this, I'd be really grateful.
Original post:
Okay, slightly annoyed and worried, and I really don't like being put in this situation.
So my friend was supposed to pay for his transportation back to the bus station so he could return home. Unfortunately he's broke and I'm 11 dollars in the hole already.
He's supposed to catch the bus to get back to the cities in an hour, all paid for in advanced, but I lack the money to put him on a Lyft or Uber to get him to the station.
If anyone could spare like 30 or 40 dollars at the absolute most, I'd appreciate it. 11.99 for the negative value of my account, plus 30 or so to account for transportation cost and tipping the driver.
I can pay you back next week if you'd like.
I was under the impression he had the money so this wasn't ever really a concern until just literally like five minutes ago. Beyond that, if I don't get him to the bus stop, that means he's godda stay here longer, and I don't have the food stuffs or resources to host him another week until I get paid.
Been transferred to U of L Trauma Unit. Just got back from another round of X-rays & CT scans. Will be having screws put in my pelvis at 6:30, unless the last scan shows a break in my neck. If that happens, the neck gets done first.
Oh for fucks sake. her lawyer sent me a semi-itemized list and let me know that besides what's on the list, everything I have purchased since the date we got married is to be turned over to a liquidator and sold.
This includes all my DJ gear, my computer, NAS, the first TV I have ever owned (considering how old I am, don't laugh, I just never had a use for a TV before my health collapsed), hell even my clothes are on the list.
Considering that she threw out almost everything I owned over the time she spent here.
This leaves me with a fedora, my tefillin, a tallis gadol, my riding leathers, my shabbos candles, and my tzaydi's siddur, and that's it.
I want to scream right now, considering how many years ago she abandoned us.
Well, fuck a doodle doo. My pubic bone has detached from my pelvic bone. Something is bleeding & they aren't sure if it's that or if I have a bowel injury as well. Dr L is consulting with the surgery team to see if they can handle it here or if I have to be transferred to a trauma center. Either way, I'm having surgery, probably this afternoon.
Almost walked out of work this morning after I was asked why I left the window unattended. I had walked across the lobby to turn the lights on out there. (They were still on dim) I was 10 seconds away if anybody had come in.
Apparently I'm supposed to let the bosses know the lights are off so they can call facilities. I literally spent less than a minute walking over & pushing a button that the facilities guys showed me so we wouldn't have to call for something that stupid.
that thing where your morning gets derailed by an app you depend on that wants you to register it on your new workstation and all you need is two separate email messages containing activation links because their magical registration system is Just So Easy™ but you can’t find (don’t have) one of those crucial email messages so you send a snarky email to the developer but they’re on BC time so you know you’ll just have to wait until… #FML
Some are curious about my age because of my recent birthday. As an older woman you must understand I'm a bit reticent to share that information. But, what the Hell, I trust you all. 😊
I'm officially I-threw-my-back-out-in-a-goddamn-coughing-fit years old. 😒
Who needs another present when, truly, this virus is the gift that keeps on giving? As if all the phlegm wasn't already enough, right? 🤦♀️