Idk, I thought we were pretty far from the current level of conversation.

Mark Wahlberg

Like from the funky bunch?

Oh good I feel this right now.

CrayonRosary provided instructions for how to tell. If this change was relevant. And they were respectful about it.

My mother passed at the same time last year. It's been a tough year and Christmas things are just making me sad this year.

You're not alone in this and I've been told it gets better.

What does the one liner do?

I don't think i could aim them that well. Do they back off?

I don't mind self checkout. It turns out i can be so incompetent that the self checkout watcher has to scan everything for me.

8 know i pay tradesman well, but I don't know how much they take home.

I don't know .net and sometimes quite some janky code, but I think in this case I would preload everything I definitely needed, locking the records I'm modifying. Then use ConcurrentDictionary.GetOrAdd(Tkey,Func<...>) to load values I might need only when they're needed.

What language are you using? Is a good idea to limit db calls, but maybe we can help with specific techniques idiomatic to your language

You're right that this could introduce regressions, but it sounds like it's making more testable.

My biggest concern would be introducing db contention with locks being held for too long, and introducing race conditions because the cached data isn't locking the records when they're cached.

Edit: your->you're