19.04.2017 13:34, Dimitry Sibiryakov wrote: > 19.04.2017 12:23, Vlad Khorsun wrote: >>> As in Sean's scenario: you pumped data into 5 tables via 5 connections >>> using 5 derived >>> transactions. Now you need atomically commit all these transactions in all >>> connections. >>> How would you do it? >> I don't. As there was no such requirement at all. You again look from >> replicator's POV - >> just wrong > > I'm looking from application developer's POV. Sean provided exact task: > transfer five > tables from one database to other as fast as possible in a consistent way.
Sean speak about *read* consistency within few transactions\connections to the same database. No more, no less. > With usage of > "derived transactions" and multiple connections it requires consistent view > of data in > source database and atomic commit in target database. Without that it is > possible to end > up with four tables containing new data and one tables (in the best case) > empty. Even if such requirement exists - nobody prevent you to use 2PC protocol to satisfy it. Vlad ------------------------------------------------------------------------------ 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
