--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > > > 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
>

Unfortunately transaction model is required
old software work on dbf without transaction
but soon had to be changed due to the critical requirement for completion of the whole transaction process

Initially the load was 100 times smaller than today.

Karol Bieniaszewski