|
|
|
|
|
by scottlamb
1681 days ago
|
|
I think you didn't read through to this part of my comment: > I think the most important thing the author learned is that failing to add an index can cost this much money before you notice. > Ideally the author and/or the vendor will also brainstorm ways to make these errors obvious before the high bill. Load testing with realistic data is one way (though people talk about load testing a lot more than they actually do it). Another would be watching for abrupt changes in the operations the billing is based on. |
|
It's also highly speculative so like I'm not going to go back and forth on it.
Needing a vendor to hand hold your likely highly paid dev seems like a bad fix to me.
Also not having an index isn't an error it can be a valid choice based on your situation and query load which is why people should know the situations when they're needed.
I think people should simply be better. A lot of people don't like hearing that though so usually I keep it to my private chats where people seem more willing to cop to that fact.
I know we disagree, I know you're going to continue disagreeing, I know I don't want to have the conversation.