> > You want a single "view" of the database from multiple _connections_. > > I still see no point for _multiple_ connections. Isn't one enough?
No -- with a single connection only 1 SQL can be executed at a time -- regardless of the number of threads to your process. Scenario: 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. 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