469,327 Members | 1,242 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

Design Consideration?

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
__________________________________________________ ______________________

Nov 23 '05 #1
1 983
"Anurag" <an**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
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
__________________________________________________ ______________________


The biggest factor to consider is how many separate SQL statements there are
(how many times the client communicates back and forth with the server). If
there more than a few separate SQL statements, then a stored procedure will
perform much faster.
Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Neal | last post: by
9 posts views Thread by ldufrane | last post: by
reply views Thread by blackpuppy | last post: by
2 posts views Thread by Leon Mergen | last post: by
5 posts views Thread by Michael Olea | last post: by
10 posts views Thread by Mr Newbie | last post: by
reply views Thread by Ice | last post: by
13 posts views Thread by steve yee | last post: by
9 posts views Thread by Grizlyk | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by listenups61195 | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.