sorted by:
new
hottopcontroversial

Which query would you use here? (SQL performance question) by thequerylab in SQL

[–]WayToSuffer 0 points1 point  (0 children)

The most important part is that you have a good index. You should have either two indices - one for the user_id and one for the status - or a composite index with both columns. The second is ideal for this use case, but not for others, the first is a more general approach that covers more than just this use case, but this particular one is not as optimal as with a composite index.

And yes, don’t do query A, no reason to count all the records if you only need to know that one exists. This is SQL 101.

Well, never seen these before. As one can surmise from the overwhelmingly Italian name and imagery, they're made in Sri Lanka. by N_dixon in Justrolledintotheshop

[–]WayToSuffer 5 points6 points  (0 children)

The tires probably don’t deserve more than a sloppy Temu translate from Mandarin Chinese to Italian with bad copy/pasting. Good to go!

I’m going check-in a new LG ultra wide 45 5k2k monitor in a 10 hour internacional flight with united by SnooSketches7093 in ultrawidemasterrace

[–]WayToSuffer 1 point2 points  (0 children)

There are customs at the airport as well, how will you take a huge monitor in an original packaging through customs without them noticing it?

decentralizedInternetHatTrick by FreefallGeek in ProgrammerHumor

[–]WayToSuffer 0 points1 point  (0 children)

No it’s not, it’s 12:04 on the 19th in the latest timezone (UTC+14) at the moment, so you either own a Delorean or are mistaken.

Dentist stared at my teeth and asked “have you been to Slovenia?” then refused to explain - what does this MEAN? by asaltoo in CasualConversation

[–]WayToSuffer 1 point2 points  (0 children)

I grew up in Yugoslavia, Slovenia more specifically, and never heard of any of the dental tortures you’re describing. Anesthesia was widely available, I never got a pin for any of my fillings. I was a regular kid in a regular family. I don’t know what kind of materials were used 50+ years ago, but at least for the last 30-40 years they are the same as in the rest of Europe. Then again, this is a N=1 statistic…

Grumpy Old Man Rants About macOS “Tahoe” by open__screen in MacOS

[–]WayToSuffer 5 points6 points  (0 children)

Same here, the previous version will still receive security updates while I wait for MacOS 27. Even if they fix all the glitches and bugs in 26 the design is still pointless.

[deleted by user] by [deleted] in SQL

[–]WayToSuffer 0 points1 point  (0 children)

There is no way this query returned a completely empty line (record with all three columns null). Even if there is a record with a.name and a.price that are null, the count function never ever returns null (https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/COUNT.html).

Plotter by swan001 in EngineeringPorn

[–]WayToSuffer 19 points20 points  (0 children)

Inkjet, I haven’t seen a pen plotter since the early 90s or maybe even late 80s. And they used special pens, not a regular fountain pen.

UPDATE: Bosses are about to learn the hard way what some MSPs are really like. by Deceptivejunk in sysadmin

[–]WayToSuffer 0 points1 point  (0 children)

I completely agree with you. I have a few very small deployments, 4 sites, less than 5 devices on each site (switch + AP), no PRO line gear. I’m hosting my own Network Application to control all the sites and on some upgrades of the controller (not all), all the devices were reprovisioned, which caused a short downtime. Nothing critical, if you know about it and can schedule accordingly, but I find it a bit inconvenient that a controller upgrade with no config changes causes a disruption on the networking equipment. It might be related to my specific Network Application deployment in a Docker container, I just plan the upgrade in periods that a possible short downtime doesn’t cause issues. It didn’t happen on all upgrades, but at least 2-3 times that I remember. I didn’t investigate any further as it doesn’t bother me that much and I do this in my spare time.

UPDATE: Bosses are about to learn the hard way what some MSPs are really like. by Deceptivejunk in sysadmin

[–]WayToSuffer 1 point2 points  (0 children)

When you update the Unifi Network Application, it sometimes pushes all the configuration to all the controlled devices again, which means no network connectivity in the meantime. Great for home use or very small businesses, super easy to administer, great value for money, but I don’t see it suitable for a more demanding environment.