wrwatson
Joined 14 years ago
Joined 14 years ago
Maybe you care about all the events that have ever happened on your incredible journey to reach a list of the customers you have today.
Or maybe it would be sufficient to have been mutating a customers table all along. If that is sufficient, then it would be faster and more straightforward to have done so.
So they turn on logging, get the SQL, and email that unreadable mess. In most of the cases I have seen, the SQL is fetching much more from the database than what the code really needs.
The first step when optimising SQL is to only ask for data that you actually need. Hibernate, as I have seen it used, defaults to fetching too many columns. I cut the SQL down, and come up with a performant statement. The developer has the challenge of translating the performant SQL back into Hibernate.
Hibernate makes easy things easier and harder things harder.
Perhaps Dang could get analytics on how many people viewed the comments and how many people clicked through to the article to answer your question.
The PCI-DSS council is partly to blame here, for recommending autocomplete=off in other contexts.
I say a fantastic experience because I played lots of people from around the world, some of whom I eventually visited in their home countries. I also improved as a developer. It was a great thrill one day to meet a friend-of-friend who loved some of the code I'd written.
I say waste of time because I spent endless hours in my early 20s glued to a telnet session. In retrospect I would have been better taking up a pass time that let me meet people in person. I've been better at avoiding addictive games since.
I'm apologising because the code isn't obvious, or the language not sufficiently expressive, or the good-idea-at-the-time no longer is. Ideally I wouldn't need to write many comments, but I often find myself sorry things are not simpler.