> 18.04.2017 21:13, Leyne, Sean wrote: > > I want to push data to another database as fast as possible, I want to have > > 5 > connections walk the list of tables and read the rows and push them to the > target DB. > > BTW, for such purpose Oracle have detached tablespaces. You detach such > tablespace from one database and attach it to other. This speed cannot be > beaten by transaction hacking.
Please stay on point!!!! How would detaching tablespace provide any solution to the use case, I am referring to?!!!!????? The tables I want to access would be "live" with activity from other connections! 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