Re: Options for poorly performing SQL
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 4 Feb 2013 10:17:00 -0600
Message-ID: <CAJvnOJYzc_RB8ys2xqvp9VT=Fu3F4zKsDDOK94CoJPh3d-+arg_at_mail.gmail.com>
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 <carlos.sierra.usa_at_gmail.com>wrote:
Date: Mon, 4 Feb 2013 10:17:00 -0600
Message-ID: <CAJvnOJYzc_RB8ys2xqvp9VT=Fu3F4zKsDDOK94CoJPh3d-+arg_at_mail.gmail.com>
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 <carlos.sierra.usa_at_gmail.com>wrote:
> <snip>
> --
> 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-lReceived on Mon Feb 04 2013 - 17:17:00 CET