Hi Kapsee,

From The Firebird Book:

"Transaction IDs (TIDs) are 32-bit integers that are generated in a
single-stepping series."

If you don't already have this book then I suggest that you get it - it's
got pretty much everything that you need to know about firebird in it.

Cheers,

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of kapsee
> Sent: Thursday, 17 November 2005 7:12 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Transaction Info
>
> Thanks for the information. What's the size of CURRENT_TRANSACTION (in
> bytes) ?
>
> Thanks!
>
> --- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> >
> > > A few questions regarding transactions:
> > >
> > > 1. Is it possible to get the transaction number in a trigger ?
> >
> > With Firebird 1.5 or higher,
> >
> > CURRENT_TRANSACTION
> >
> > > 2. Are the transaction numbers assigned in an increasing
> sequence ?
> > >
> >
> > Yes and no. Yes they are assigned in increasing sequences, but they
> > reset to 0 if you restore, so if the next transaction is
> 100, and you
> > back it up and restore it, it goes back to 1.
> >
> > > 3. gstat gives information about the oldest transaction and oldest
> > > active. What is the difference between the two ? Is it possible to
> > > obtain this information using any firebird API ?
> > >
> >
> > I forget this myself. The difference between the two is bad if it is
> > too large. Ideally, they should remain pretty close. If the
> gap is too
> > big, then old record versions will start clogging up the
> database with
> > garbage. The normal culprits are commit retaining and rollback
> > retaining, which do not release the context and so do not help the
> > garbage collection.
> >
> > Some light reading ;)
> > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_expert4
> >
> > I don't know if it is possible through the API.
> >
> > Adam
> >
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Get fast access to your favorite Yahoo! Groups. Make Yahoo!
> your home page
> http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>