Re: MTS & Oracle 8i

Please explain - "Ms says this is more efficient.". Is someone at MS telling you that distributed transactions are MORE efficient???

Using MTS / DTC to manage distributed transactions incurs additional overhead. There are environments where a 2-phase commit makes sense, but it isn't a magic bullet that should blindly be applied.

See Oracle's documentation - Performance Tuning, Chapter 6 - Tuning Oracle Service for MTS Performance under the topic "Optimize your programming methods". (Note: the concepts are good for any DBMS when working with MTS, not just Oracle.)

Depending on the relative complexity of your middle-tier objects, you might find that the increase in performance is worth manually coding transactions (its really not that much work, anyway).

Mike

"Rod Sherer" <rsherer_at_prescientsystems.com> wrote in message news:38fc52b5_at_news.deniz.com...
> Actually, we are using it so that we can pool the connection threads
 through
> MTS, rather than keeping one connection open throughout a "batch job"
> session. This was recommended by Microsoft.
>
> Each time we run a CRUD statement, we open a new connection, run the
> statement and close the connection. Supposedly, MTS will take care of the
> commit and rollback through the SetAbort/SetComplete ObjectContext
 commands,
> as long as we are building our objects to Require Transactions (which
 opens
> up an entirely different can of worms). Ms says this is more efficient.
>
> We are not working strictly with Oracle either. Our objects can also
> connect to SQL Server (never simultaniously though. It is intended that
 the
> user choose either/or).
>
>
> MMayer3077 <mmayer3077_at_aol.com> wrote in message
> news:20000417210105.15549.00001918_at_ng-cr1.aol.com...
> > Wait a second. I think that by using the MTS against an ORACLE
 instance
 you
> > are doing too much. VB works fine against ORACLE. The MTS is the
 transaction
> > server which was built to host a mult user envirorment which is what
 ORACLE is
> > a already all about. I would suggest just trying to get to your ORACLE
 thru
> > the OLE interface. I don't see why you want MTS to talk to ORACLE
 unless it
> > would be to try to SYNC to databases sharing common data etc.
>
>
Received on Tue Apr 18 2000 - 00:00:00 CDT