Re: Return rows as 1 line?
From: joel garry <joel-garry_at_home.com>
Date: Wed, 19 May 2010 10:20:22 -0700 (PDT)
Message-ID: <b16284bc-fc1a-493f-9a69-f172d5458111_at_v12g2000prb.googlegroups.com>
On May 18, 6:58 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On May 18, 7:59 pm, galen_bo..._at_yahoo.com wrote:
>
> > But the question should just be, where is the most performant place to
> > do this. Who gives a hoot if you add non-relational functional to the
> > database to get a job done?
>
> Our corporate controller. A developer of ours found this function on
> asktom and cut and pasted it into the application. Voila...instant
> CPU spike on the server whenever the query is run. If more than one
> session runs it? Geez, alarms start firing everywhere.
>
> In our case, it made more sense to have a procedure return a cursor to
> the application and then build up the string in java (which is free).
Date: Wed, 19 May 2010 10:20:22 -0700 (PDT)
Message-ID: <b16284bc-fc1a-493f-9a69-f172d5458111_at_v12g2000prb.googlegroups.com>
On May 18, 6:58 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On May 18, 7:59 pm, galen_bo..._at_yahoo.com wrote:
>
> > But the question should just be, where is the most performant place to
> > do this. Who gives a hoot if you add non-relational functional to the
> > database to get a job done?
>
> Our corporate controller. A developer of ours found this function on
> asktom and cut and pasted it into the application. Voila...instant
> CPU spike on the server whenever the query is run. If more than one
> session runs it? Geez, alarms start firing everywhere.
>
> In our case, it made more sense to have a procedure return a cursor to
> the application and then build up the string in java (which is free).
Our controller asked for an additional filter to a report that causes a cpu plateau for 15 minutes. The funny thing is, it runs in seconds without the filter. There are too many variables to predict what will happen to the OLTP that would be affected by adding an index to fix this. The SQL comes from a code generator, can't simply hint.
We live in interesting times.
jg
-- _at_home.com is bogus. Roger Waters is putting together a Wall tour. http://www.signonsandiego.com/news/2010/may/19/house-gop-stops-major-science-technology-bill/Received on Wed May 19 2010 - 12:20:22 CDT