A real transaction count for a non-hypothetical large system (not
firebird): 1.2 million database transactions per hour (8000 per second),
24x7.

I am aware of several systems that are 4 to 8 times as heavily used as
this particular one.

That's 149 days!

On Tue, 2006-03-14 at 13:24 +1100, Alan McDonald wrote:
> > > a diff of 1 between oldest and next...
> > > Now lets do some sums
> > > April 14 to Nov 15 last year = 150 days
> > > therefore 7200 transactions per day
> > > is that high? is that low? - high to some, low to others, very low
> > to yet
> > > others.
> > > 5 Transaction per minute
> > > Lets dream up a very heavy website
> > > 50 Transactions per second (can your CPU and HD handle it?)
> > > 4 million Transactions per day
> > > Total available
> > > 2,147,483,648
> > > = 536 days
> > > Not long at this rate....
> >
> > A bit more, I think it is unsigned (or at least the book refers to
> it
> > as a 4GB limit, so make that ~1000 days)
>
> so are we saying that the transaction IDs start at the negative
> extreme?
> that's unusual..
> Alan