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.

This still doesn't explain why you need something so large.

The following is not meant in a derogatory way but it is my experience that the less experience someone has the more code they write. If you can better explain what you are trying to do someone may be able to help you break it into logical segments or write far less code that accomplishes the same result.

One thing I notice is your concern about the number of round trips to the webserver. Why? Is there a known performanc problem? Are you passing single records back and forth or arrays? Are you using cursor loops or bulk collection?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)