HIVE MIND for software developers: I’d like your help – and your stories!
I’m working on an article with a tentative title of “Tales of the Crypt: Horror stories where database performance caused a real problem.” It’s meant to be schadenfreude nostalgia, about your late nights coping with a performance issue (with, hopefully, a happy ending of “…and this is what we did to fix it”).
So, what happened? Tell me about it.
@estherschindler Oh, goodness, I have many of these, from an e-commerce site that needed 10 seconds to load a search page due to missing indexes and not using a proper in-memory store (thus resulting in e-commerce users going *back* to calling the call center, and getting them off it was the whole point!) to a website that randomly hung due to transaction isolation issues (and missing indexes), creating an impressive Heisenbug.
I'm open to describing any of these in more detail if you'd like :)