> > 2- that the cost of any approach to ensure such "alignment" will not be so > significant that it compromises system performance. > > The simplest method: ON COMMIT trigger waiting for some flag to be > unset. You set flag, start your transactions and then reset the flag. > Performance penalty is minimal because a) is applied only to transactions > that writed to targeted tables;
Again, you are thinking far too narrowly -- trying to define a problem to convenience frame of reference. > b) not more than time needed to start 5 transactions which is small. Really, how do you propose to coordinate the transactions account the separate processes (potentially different hosts)? > > Reminder: Nikolay worked for BroadView for several years. If the solution > was simple, we wouldn't be having this discussion right now. > > Taking into account that you consider ad-hock queries to be a good solution > from performance POV, I'm pity for Nikolay who surely did his best to make > your system work. Ad-hoc queries?!!??? Huh??? Where was I advocating Ad-Hoc queries? 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