Thanks. I kind of expected it to be larger than that. With 32 bits,
don't the numbers wrap not too infrequently ?

Thanks!

--- In firebird-support@yahoogroups.com, "Ryan Thomas" <ryan@t...> wrote:
>
> 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@t...
> 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
> >
> >
> >
> >
> >
> >
> >
>