Subject Re: Transaction Info
Author Adam
--- In, "kapsee"
<kapil.surlaker@g...> wrote:
> Thanks, Ann.
> I also had a question about Transaction IDs, I haven't gotten a
> definite response to this so far.
> In version 1.5, are the transction IDs still 32 bits or do they go
> to 64 bits ?

32 bit

> If they are 32 bits, what happens when they wrap ?

To quote the Firebird Book "bad things will happen".

You wont be able to start a new transaction.

> Does
> the garbage collection handle that ?


Make a backup then restore it to reset the transaction back to 0. At
100 transactions / second, you will want to do it annually, at 1
transaction / second, you wont still be using that server when it
falls to pieces, heck none of us will be alive.