Re: Using pipelined functions

Carlos Correia wrote:
> In short what i'm trying to achieve is reduce the number of round trips
> from our webservers to our databases, as well as abstract the bulk of
> the sql logic to a package in the database. There is a fair bit of
> logic and string manipulation involved in achieving this. Also the
> table i'm dealing with contains 24million rows, and I'd like to
> minimise the amount of knowledge required by the webmaster.... so I
> simply create the functions he needs to achieve the results, and he
> then uses them in the site. This way the sql statements on the website
> a relatively simple and the more complex queries using ranks etc. Also
> if any tuning needs to be done it can be performed at the database
> level rather than changing queries on the site.
>

What you write is all fine and valid, however it does not explain the need to write a 1000 line function for something that sofar was explained more or less as an select.

Perhaps you care to explain what makes that function so special that it can't be done with a select - and be sure to make the distinction between *it* can't be done and *I* can't do it.

Just my thoughts

Holger Received on Fri Jan 07 2005 - 05:46:27 CST