> > > Hi
> > > i need to know if this limitation exists or not.
> > > transaction enumeration in Firebird is max integer or unsigned

integer?

> > > and what happens when i reach 2^31=2147483648 transaction ID or if
> > > is unsigned 2^32=4294967296 i read somewhere that in FB1.5 this
> > > corrupt database - what about with 2.1.4 and new FB2.5, FB3.0?
> > > Karol Bieniaszewski
> > >
> >
> > In 32 bit positive range, at a rate of 1 transaction per 30 seconds
> > average. That's 2,108 years between backup and restore cycles
> >
> > Alan
> >
>
> Hi Alan,
>
> then you confirm that this limitation exists?
> I yes i am in bad situation
> because now i have ~18 000 000 transaction per day this is ~200

transaction

> per second :/
>
> I see that i need to take off line my database after <4 month :/ This

counter

> not restart self?
> I really need to backup and restore cycle?
>
> Karol Bieniaszewski
>

Personally I wouldn't have gone down the track of using FB for that
transaction rate. I'd actually wonder to myself if I needed a transactional
database at all.
Perhaps you would have been better off with MySQL without transaction
tables?

Alan