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. 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. Of course, as an experienced application developer, I wouldn't use multiple connections at all (they are just ancient workaround for MS SQL limitations), but in this thread we are stuck on this "solution". -- WBR, SD. ------------------------------------------------------------------------------ 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