Re: Options for poorly performing SQL
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: michael.fontana@xxxxxxxxxxx
- Date: Wed, 6 Feb 2013 16:10:05 -0600
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@xxxxxxxxxxx
> wrote:
> << -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Andrew Kerber
> Sent: Monday, February 04, 2013 11:17 AM
> To: carlos.sierra.usa@xxxxxxxxx
> Cc: sbecker6925@xxxxxxxxx; 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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
