Subject Re: [firebird-support] Oldest transaction stuck
Author Ann Harrison
Thomas,
>
> So you say that a gap OAT-OIT of 24 mio in this case doesn't harm server
> performance? I thought, each transaction start has to read the TIP pages
> starting from the OIT to the OAT, which is quite a number here.
>

superserver reads that list on startup and keeps a single bit vector. Classic reads the pages on connect and keeps a bit vector per connection. A cost, sure, but not huge.

Cheers,

Ann