No, there's a good example in the FB book, at 100 transactions per second it
will take 1 year, 4 months, 11 days, 2 hours and about 30 minutes to roll
over, plus backing up and restoring resets the TID!

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 8:16 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Transaction IDs
>
> 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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>
>
> ------------------------ 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
>
>
>
>
>
>
>