On Mon, Aug 15, 2011 at 11:39 PM, K. Peachey p858snake@gmail.com wrote:
On Tue, Aug 16, 2011 at 7:03 AM, Maarten Dammers maarten@mdammers.nl wrote:
Ah, you are the one who killed the categorization bot. Thanks for announcing that beforehand (not!). It's very annoying that you suddenly just decide to deploy a new toy the screws up our tools.
Maarten
It was re-enabling a service that has been around for a long time that [accidently] broke at one stage and because of the TS performance not being degraded was never really noticed or cared about.
Recently a TS box went down and caused major issues (Replag was easily over 2 days at one stage for those databases) for the backup box handling the effected databases, DaB was monitoring this by hand and manually killing the processes to keep this somewhat saner then re-wrote and brought the tool back online to handle this when they noticed it was [the tool] was not functioning.
This was a tool that was already meant to be running but by [your] "luck" wasn't, and was already documented on wiki as DaB pointed out over a year ago.
Perhaps you should consider apologizing to DaB in regards to the tone of your email.
While it's wrong do insult DaB (or anyone here :-) I feel the annoyance. It doesn't really matter if it was "supposed to" be running but wasn't for some reason we mere mortals can't comprehend - queries were fine, and then they suddenly they were not. I understand there are reasons behind this (hardware failure, miser mode), but they weren't obvious from the original mail.
So now I (and others, I suspect) are inserting /* SLOW_OK */ into queries. That doesn't make the queries less or faster, but it returns service to normal (for the tool writers, and the tool users). German speakers might be familiar with the phrase "wenn's denn der Wahrheitsfindung dient..."
Should we (the tool authors) make our queries faster? Absolutely. Can we? Sometimes, maybe. Usually not. That might be due to personal qualification, or system constraints. The local version of the "work smarter, not harder" mantra is unlikely to improve the situation.
Cheers, Magnus