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. ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel