I am trying to convince my Manager and DBAs here to
change the way they manage Database transactions in
here.
The environment is ColdFusion 5.0, DB2 version 6, DB2
connect
The current setup is as follows.
---------------------------------
1. All access to the database is through Stored
Procedures only.
Right now they have the concept of building generic
inserts, updates and
deletes to each table.
2. They want to set up transaction processing using
cftransaction
to keep the DB2 stored procedures simple.
For example say there are 3 tables.
tableA, tableB, tableC
Say my transaction requires
1. delete row from tableC
2. update row in tableB
3. insert new row in tableB
4. insert a row in tableA
then as per the current practice here I have to do
this
<cftransaction>
<cfstoredproc procedure="SPLdeleteTableC">
</cfstoredproc>
<cfstoredproc procedure="SPLupdateTableB">
</cfstoredproc>
<cfstoredproc procedure="SPLinsertTableB">
</cfstoredproc>
<cfstoredproc procedure="SPLinsertTableA">
</cfstoredproc>
</cftransaction>
Now to my Question:
------------------
1. I am trying to convince the processing would be
quicker
if the transaction processing is also built inside
another
Stored Procedure. I am arguing at least give me an
option of doing
transactions inside the database by providing a
controller stored procedure
that sets up the transaction and makes nested calls to
the generic ones.
2. I know the processing would be quicker, but I am
trying
to give them some numbers and a comparison of how much
improvement we can achieve by moving the complexity
into
Stored Procedures.
Can someone point me in the right direction. Also can
someone
tell me what other Issues i can bring up in support of
my
case.
thanks
sudhakar
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
