473,395 Members | 1,658 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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 1051
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Neal | last post by:
I'm thinking about so many posts I've read and answered in the past month - here's where my brain is at. Feel free to add and comment as you see fit. The biggest problem in web design is choosing...
9
by: ldufrane | last post by:
Hi All, I just started a project, which features various great websites that use CSS/web standards, this projects also highlights what techniques they use to create the wow effects, in certain...
0
by: blackpuppy | last post by:
I need to allow the user to design the report format at runtime. I'm studying with what tools that I can do that. The users need to design the report/document by themselves because they are in...
2
by: Leon Mergen | last post by:
Hello, I'm currently in the process of implementing a file cache, and am looking for any existing design patterns. I hadn't had much luck with google, is anyone aware of a good file cache...
5
by: Michael Olea | last post by:
Here is a design problem I ran into this am - and I have cleaned the bathroom, scrubbed toilet sink and tub, windexed all glass, mopped the floor, and vacuumed the house - no dice, the problem is...
9
by: sk | last post by:
I have an applicaton in which I collect data for different parameters for a set of devices. The data are entered into a single table, each set of name, value pairs time-stamped and associated with...
10
by: Mr Newbie | last post by:
Does anyone have any recommendations for a really good book, or web site article on design of N-Tier systems using .NET -- Best Regards The Inimitable Mr Newbie º¿º
0
by: Ice | last post by:
All - I just wanted to folks thoughts on what "ideal" webservice design is based on their experiences taking into consideration the two observations (and any others you may have) below: 1....
13
by: steve yee | last post by:
strcpy() returns it's input parameter. i asked a similar question on c++, most people seem to not think it as a problemic design. how do you think of this? ...
9
by: Grizlyk | last post by:
Somebody have offered std colors to C++ in the msg here: http://groups.google.com/group/comp.lang.c++/browse_frm/thread/2e5bb3d36ece543b/1acf6cd7e3ebdbcd#1acf6cd7e3ebdbcd The main objection to...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.