artmt_at_hotmail.com wrote:
> 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?
>
> Thanks
> -Art
>
How does having one big servlet that has to pack and unpack the call and
result set to and from a bunch of back end services simplify the middle
tier ? You have just as many setups, invocations and subsequent
processing of the results as before, but now you have them all in one
big servlet that is also incurring a cost to wrap the call. Sounds to me
that you have just added a layer of complication, and not simplified
anything at all.
Received on Tue Aug 07 2007 - 22:20:35 CDT
