Hi,
Posting this question on my friend's behalf
________________________________________________________________________
Question:


Let us say I have a SQLJ Java application and there is šunit of work
that does 50,000 SELECT statements, and 10,000 INSERT statements.
I need to determine if the unit of work (UOW) should be performed using
code executing on the application server (WebSphere Application Server)
, or should it be executing code on the database server, using a stored
procedure.
I would be interested in knowing how others have dealt with this
architectural decision. šDo you make a high level decision that
dictates where the database access logic resides ? Or Do you make the
decision as per the UOW requirement ? š small UOW - application server
will do, large UOW - database server.


Thanks
Anil
________________________________________________________________________

************************************************************


************************************************************
HSBC Software Development (India) Pvt Ltd
HSBC Center Riverside,West Avenue ,
25 B Kalyani Nagar Pune 411 006 INDIA

Telephone: +91 20 26683000
Fax: +91 20 26681030
************************************************************

-----------------------------------------
***********************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.

Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
***********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page