Re: Performance concerns with a single db functions servicing all data requests

artmt_at_hotmail.com wrote in news:1186539537.565447.282590 @w3g2000hsg.googlegroups.com:

> I am considering data access solution where every data request from
> the applications invokes a single stored function, and I am wondering
> if may result in resource contention.
>
> The single generic function will accept a CLOB containing the id of
> the calling process and the list of arguments - all recorded as XML
> document. Based on this information the function will figure out what
> stored programs to call, will execute them, and will return all
> requested data in XML format (as CLOB).
>
> The objective of this approach is to move all data access logic from
> the mid-tier to the database, and to simplify mid-tier development by
> having just a single servlet.
>
> Can many simultaneous calls to the same PL/SQL object (disregarding
> any possible data contention) in any way affect performance?

The "simultaneous calls" will NOT be accessing the "same PL/SQL object". Each session will be using its own instantiated PL/SQL object. Received on Tue Aug 07 2007 - 21:52:41 CDT