“Werry good poer o’ suction, Sammy,” said Mr Weller the elder, looking into the pot, when his first-born had set it down half empty. “You’d ha’ made an uncommon fine oyster, Sammy, if you’d been born in that station o’ life,”<\/i>Charles Dickens, The Pickwick Papers <\/p>\n
One of the great pleasures of programming in a team is the pub lunch. It is something I always relish, particularly on a Friday, for the refreshments, the gossip and the companionship. I thought that this ancient ritual was an international one until I worked for a while in Japan, and discovered to my horror that it was soft drinks only until the sun went down. At first I thought this was due to their abstemiousness until I saw the propensity of the Japanese engineer or programmer for consuming the stuff once the sun had dropped. <\/p>\n
Nevertheless I always wondered whether there was a moral dimension to celebrating the end of the working week with a couple of pints of best Bitter. Is it true that one’s capacity for work drops after the Amber Nectar has hit the bloodstream? I have always doubted it. Do careless errors slip into ones’ code after the beverage hits the bladder? My own experience tells me not. Once the warm glow of the hops descends on my soul, I feel calmer, and more confident. and less distractible. My best ever code has, I have always considered, been written with a jar of Stout in one hand and a cigar in the other. <\/p>\n
There will be some, particularly those with the cold grey ice of Puritanism in their souls, who will click through their teeth and protest that I would be better off drinking water and breathing in fresh invigorating air. <\/p>\n
This should be put to the scientific test. I have of course done the best I can but my results are merely indicative. I have conscientiously plotted the average number of times I have hit the compile button before a stored procedure has compiled without errors, against the number of half-pints of Beer I have consumed. The data was collected over a period of a month. The results, for what they are worth are: <\/p>\n
| Consumption<\/th>\n | Errors per Stored Procedure<\/th>\n<\/tr>\n |
|---|---|
| Sober:<\/td>\n | 4<\/td>\n<\/tr>\n |
| Half a pint <\/td>\n | 3.2<\/td>\n<\/tr>\n |
| One pint<\/td>\n | 2.87<\/td>\n<\/tr>\n |
| One and a half pints<\/td>\n | 3.2<\/td>\n<\/tr>\n |
| Two pints<\/td>\n | 4.8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n The problem with these results is that they take no account of the ‘Placebo Effect’. My error-rate may be more closely related to my subconscious will to come up with the result I want. For a controlled experiment, a whole range of programmers, selected by random numbers and balanced so as to represent a true sample of the population of programmers, should be given both real beer and an alcohol-free ‘Placebo’ beverage that is indistinguishable from it. It should be done at various times of day with a full range of database tasks. It is an indictment of the poor state of academic psychology that such a task has not yet been undertaken. Of course, for all I know, a PHd thesis may already lie neglected in some university library with the truth already firmly established <\/p>\n Should the community of database developers and DBAs unite to determine this issue once and for all? If it can be proved beyond all doubt that a good beer actually improves ones programming skills then maybe one can claim the cost of purchase against tax? <\/p>\n Your views and comments would be most welcome.<\/p>\n If it be true that I do think “Werry good poer o’ suction, Sammy,” said Mr Weller the elder, looking into the pot, when his first-born had set it down half empty. “You’d ha’ made an uncommon fine oyster, Sammy, if you’d been born in that station o’ life,”Charles Dickens, The Pickwick Papers One of the great pleasures of programming in a team……<\/p>\n","protected":false},"author":154613,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-2293","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/154613"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=2293"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2293\/revisions"}],"predecessor-version":[{"id":41374,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/2293\/revisions\/41374"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=2293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=2293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=2293"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=2293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |