RE: Slightly-OT: Throw HW at a SW/DB problem

From: Kenneth Naim <>
Date: Wed, 29 Jun 2011 12:13:52 -0400
Message-ID: <005001cc3677$8ac69520$a053bf60$>

>>There must be some good and well written apps out there! Somewhere?

There are good applications out there but the better and more expensive the dba/developer is, the less likely he/she is to run into it on his/her travels, as they will not need emergency tuning as either the vendor or the company has sufficient quality dba's/developers to support them. This is true regardless if the dba/developer is full time or a consultant as this systems would get the least exposure as they are the problem free ones. Firefighters rarely look at houses not on fire.


-----Original Message-----
From: [] On Behalf Of Dunbar, Norman (Capgemini)
Sent: Tuesday, June 28, 2011 4:49 AM
To: Jonathan Lewis; Subject: RE: Slightly-OT: Throw HW at a SW/DB problem

Morning Jonathan,


>> The logical fix is sometimes simple, the necessary code change tends
to be
>> harder - unless you catch it very early.
True. And so far, in the contracts I've been on, the only time I see a database, as a production DBA, is when the thing has passed through the myriad layers of management and so on, and then it goes live. The money has been paid, the contracts signed - and we are stuck with it.

I've had multi-user systems running "SELECT MAX()+1" queries on the database to get the next "sequence" because the application is "database neutral". I already mentioned that everything I see has a parse:execute ratio of 1:1.

There must be some good and well written apps out there! Somewhere? Surely? One day, perhaps, I'll come across one.


Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at


Received on Wed Jun 29 2011 - 11:13:52 CDT

Original text of this message