Re: Options for poorly performing SQL

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 6 Feb 2013 16:10:05 -0600
Message-ID: <CAJvnOJY+Z1co=sCBM04AGA3jObFhBo8kFPpLZE3az=b+=AQ_Cw_at_mail.gmail.com>

Oh, I agree completely with your evaluation. Unfortunately, in this day and age too often the coding team is contracted for outside the company, and you as a dba dont have any real control over them. I wouldnt call it a disdain for the underlying database, I would call it ignorance of the underlying database. Typically these are java programmers that are taught that any slowness is a database problem, and that the underlying code is irrelevant.
On Wed, Feb 6, 2013 at 3:55 PM, Michael Fontana <michael.fontana_at_enkitec.com
> wrote:

> << -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Andrew Kerber
> Sent: Monday, February 04, 2013 11:17 AM
> To: carlos.sierra.usa_at_gmail.com
> Cc: sbecker6925_at_gmail.com; oracle-l
> Subject: Re: Options for poorly performing SQL
> I have had this problem before, and while part of the problem is most
> likely the dynamically generated sql, the core of the problem may well be
> that they simply do not know how to change the code that is generated. I
> have run into that case before, I identified bad sql, sent it to them, and
> got no response at all. After some digging I realized that all they really
> knew was how to work with the Java objects to get data from the database,
> they had no understanding of where the code was actually coming from, what
> it said, or how to change it.
> On Mon, Feb 4, 2013 at 10:03 AM, Carlos Sierra >>
>
>
> The root cause is that people who write application code appear to have an
> unreasonable disdain for everything not in the programming language of
> choice, of which SQL is notoriously not. The only way I've ever seen this
> overcome is to have a database programming design and development group.
> Anyone who designs a database application without rigorous attention to
> the critical database interface to their application are simply not serious
> or professional at all.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 06 2013 - 23:10:05 CET