Hi Tarno

We use a very simple approach which is probably not optimum but works fine.
Everything uses the default transaction (readcommited) except for actions
which must be bundles together - eg when replacing some data lines by a
delete and insert, either the whole thing must succeed or nothing must
succeed.

Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of tarno_nona
> Sent: 27 June 2007 05:17
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] When do we need more than one
> TIB_Transaction in an application?
>
> > There is no simple answer to this question - it always
> comes down to
> > your actual needs, load, environment, etc.
>
> So many choices, how do we test which choice is better?
>
> Tarno
>
>
>
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>