Forum OpenACS Development: Re: cc_users considered harmful (sometimes at least)

Collapse
Posted by Dirk Gomez on
Views are nice for abstracting information - in fact they are the Oracle-recommended way of "information encapsulation". We still very much rely on PL/SQL functions for doing so which usually gives us performance grieving...

The danger with views - evidenced frequently enough in OpenACS - that they retrieve more information than needed in the "master query".

No PL/SQL functions that perform banal operations :)