> It can. Nothing prevent you from starting several read-only snapshot > transactions at once. If they all are started without any commit between > them (which can be ensured by a number of different ways)
Really, how? I have client with over 500 connection to a database, I am pretty sure that: 1- there is no way to ensure that all the read-only processes can start a transaction without the possibility that another read/write transaction started in between them, or 2- that the cost of any approach to ensure such "alignment" will not be so significant that it compromises system performance. Sean ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel