3 ms·
In some ways understanding computation actually undermines you. Here's a true story, a few years ago I was a DBA on a large-ish Oracle database (~50T) supporti
by gaius 11y ago
In some ways understanding computation actually undermines you.
Here's a true story, a few years ago I was a DBA on a large-ish Oracle database (~50T) supporting many users. One guy would run his report, and it would time out (in his client software, Business Objects I think). So he would run it again and it would time out. But on the 4th or 5th attempt, it would work! Why was this? I was curious enough to investigate and what was happening was he was gradually getting more and more of his working set into the cache, and eventually he had enough in-memory that his query could complete in time. Let me tell you for sure, that guy did not have any mental model of computation that led him to discover this. He just tried it and it worked. Would a guy with a classic CS education have done this?
- paulryanrogers 11y agoWhile his solution worked for him, it also revealed a flaw that could've been a deal breaker if sales were demoing the system. Of course what constitutes a significant problem is often up to a nontechnical department.
- toomuchtodo 11y agoIf sales was demoing it, they would've pre-warmed the cache by running the report until it no longer fails before the demo. Not that I've seen sales people do such activities before...