brugroffil posted:

https://twitter.com/BusinessInsider/status/1427636676009107470

Nocturtle posted:

Someone who got their third shot told me that the CVS person asked them to verify all their fake info, fake address + fake phone number etc. They were able to do it but it put me right off the idea of getting an illegitimate 3rd shot, no way I wouldn't choke when put on the spot like that. Sounds like grocery store pharmacy workers might care less on average?

Turns out boosters are coming soon for everyone anyway, of course before my kids even get their first.

Relevant Tangent posted:

What an odd take. Seems demeaning almost? People in the various service industries aren't servants.

Mr Hootington posted:

Glenn is normally very right...

Platystemon posted:

Oh yeah that’s fine.

As for the clicking valve, some models are stiffer than others. They can all get clicky if soiled. You’ll want to clean the valve and mating surface if a respirator that hasn’t been clicky starts to.

Sunny Side Up posted:

can someone make an updated GIF?

empty whippet box posted:

god, im glad i live in the US, where I'm free from the horrific effects of sustained social isolation. here I only have to deal with the constant threat of gun violence, 650,000 people dying of a preventable disease, extremely low wages, homeless people on literally every single street I walk down, and the ever-present threat of still getting covid even though i'm vaccinated, and god, compared to the horror of sustained social isolation I am just so so so happy I live in a FREE and CIVILIZED country otherwise my mind would be COMPLETELY hosed and I would be laughing like the joker pretty much constantly. Haha!!! HAHAHAHA!!!! ehehehe ahahhahEeuheauhaha

corona familiar posted:

i did my best (one of the images were out of order in the album, and i tried to guess dates)

Forseti posted:

I have no idea what their code looks like, but it's not going to scan every row with an index there* if it's written in a way that can use the index (which yours is). Even if it did, 100k rows should be a joke to a modern server, especially with caches.

What it most likely would decide to do given your query and index is index seek at O(log*n) to get the page's worth of indexes, then retrieve the data for only those rows. Although in the case of the drop down, they shouldn't be pulling back the entire row data to populate it since it doesn't use that.

There are a lot of things you can do to speed things up, starting with at least a prepared statement so it doesn't have to go through the query planner every time. For something that gets done very frequently though they should really be using a stored procedure.

* In general. The query engine can decide that it's faster to scan depending on its statistics and what exactly the query is doing. This is one of the reasons it's important to keep the statistics up to date, which can be a nightly task (or however frequently it starts getting out of whack).

The cost of a growing thread should scale like the red line here but it's very easy to mess it up and end up with the cyan line or worse if the developer is just banging out naive code (or letting some ORM library write the code for them because SQL is "too hard")

To tie it to the thread, this stuff is depressingly similar to epidemiology from what I can tell. Paying people who know what they're doing is too hard and they also tend to tell you things you don't want to hear. Just let some dingus who doesn't know wtf a database is bang it out with the ORM for max quarterly profits.

Nocturtle posted:

Someone who got their third shot told me that the CVS person asked them to verify all their fake info, fake address + fake phone number etc. They were able to do it but it put me right off the idea of getting an illegitimate 3rd shot, no way I wouldn't choke when put on the spot like that. Sounds like grocery store pharmacy workers might care less on average?

Turns out boosters are coming soon for everyone anyway, of course before my kids even get their first.

Forseti posted:

I have no idea what their code looks like, but it's not going to scan every row with an index there* if it's written in a way that can use the index (which yours is). Even if it did, 100k rows should be a joke to a modern server, especially with caches.

What it most likely would decide to do given your query and index is index seek at O(log*n) to get the page's worth of indexes, then retrieve the data for only those rows. Although in the case of the drop down, they shouldn't be pulling back the entire row data to populate it since it doesn't use that.

There are a lot of things you can do to speed things up, starting with at least a prepared statement so it doesn't have to go through the query planner every time. For something that gets done very frequently though they should really be using a stored procedure.

* In general. The query engine can decide that it's faster to scan depending on its statistics and what exactly the query is doing. This is one of the reasons it's important to keep the statistics up to date, which can be a nightly task (or however frequently it starts getting out of whack).

The cost of a growing thread should scale like the red line here but it's very easy to mess it up and end up with the cyan line or worse if the developer is just banging out naive code (or letting some ORM library write the code for them because SQL is "too hard")

To tie it to the thread, this stuff is depressingly similar to epidemiology from what I can tell. Paying people who know what they're doing is too hard and they also tend to tell you things you don't want to hear. Just let some dingus who doesn't know wtf a database is bang it out with the ORM for max quarterly profits.

mod sassinator posted:

if things are slowing down only for people on slow computers then it's not a problem on the DB or server side. i've noticed android's chrome browser freaking _hates_ if you open the list of pages in a long thread. like it shoots every core of your phone up to 100% use and grinds the whole OS down to a halt until you can force close the application. it's probably something very very dumb in the client side JS that scales badly with the number of pages. perhaps it's calculating 7000 individual hrefs for each "jump to page" link with all kinds of string concatenations, etc. and populating them all inside a drop down instead of just figuring it out when you select one

Thoguh posted:

Bruce Hussein Daddy posted:

Today


Yesterday


Since Jul 26
https://imgur.com/a/j5Ag7mG

source: covidactnow.org

Thoguh posted:

https://twitter.com/garthbrooks/status/1424877090407690240

Thoguh posted:

Blaziken386 posted:

third shot, get!

questions asked: none

the only other person in the lobby was an old lady also getting her third shot, who said, and I quote, "I'll take as many as they'll give me", so she'd fit right in here lol

Thoguh posted:

https://twitter.com/garthbrooks/status/1424877090407690240

Thoguh posted:

Biowarfare posted:

why the gently caress was this not canceled

skewetoo posted:

Incredible right. Now what if I told you there has been 0 (zero) transmission from this gathering despite what the doomers are saying.

PerniciousKnid posted:

Remember when picture threads had to warn dialup users? Makes you think.

Glumwheels posted:

I’m starting to think my 4th shot will be Moderna. I don’t think Pfizer is doing it.

Pittsburgh Fentanyl Cloud posted:

A regular poster around these parts who grew up in New Orleans has posted that the introduction and interview poo poo for any job involves sussing out what high school you went to, since the city is so highly segregated by race and wealth that the interviewer will know what kind of background you came from with that one question. cool.

RoboChrist 9000 posted:

Thanks. So yeah, it's fine that it only gets air leak when I exhale with the valve covered. During normal operation it is - insofar as I can tell - fine. And it passes the negative pressure check just fine.
Am I correct in assuming it's not really possible to pass one test and fail the other since I mean a seal is a seal no?

Forseti posted:

^^^ I used to be a DBA lol. I feel Eric Crackle-Ping's pain.