Re: [Firebird-devel] Firebird Transaction ID limit solution

[Dimitry S. <sd...@ib...>]

03.01.2012 21:04, Kjell Rilbe wrote:
> What's needed is, in principle, a task that reads through ALL record
> versions, and for each one with transaction id<  OIT, change it to OIT -
> 1. When it has done that for the entire database, it can move the max
> useable transaction id to OIT - 2.

   It means to fetch/read every page with exclusive lock, modify it, mark it as a dirty 
and write it back to the disk (when?). Crazy i/o load and long lock waits are guaranteed.

-- 
   SY, SD.