In effect you are talking 60000 client server interactions, most of which
involving result sets.
I would see what I can push onto the server. Note that a procedure is
merely an extension of the application running on the server.
It typically does NOT comprise a complete transaction (of course it CAN).
So look through your code. and ask yourself whether the data shuffled to
the application is actually consumed by the application. If not leave it at
the server.
Of course what you do is push client CPU load to the server CPU while
saving network traffic.
So make sure your server isn't already maxing out.

Cheers
Serge


"kumaranurag" <db2udbdba-ezmlmshield-x84270602.[Email address protected]
wrote on 11/22/2005 11:16:31 PM:

>
>
>
>
> 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.
> ***********************************************************************
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


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