Just throwing another thing: Isn't some form of journaling expected to appear in Firebird, as I've heard in the past?
If yes, the journal could be used to consolidade old transaction in one and implement the thing about adjusting the transaction number and making it overlap as I said previously, without needing to scan the whole database. Adriano ------------------------------------------------------------------------------ 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