> > Really, how do you propose to coordinate the transactions account the > separate processes (potentially different hosts)? > > What? So far you talked about transactions from one multi-threaded > application. Where "different hosts" came from all of sudden?
I never said anything about a single application! I mentioned in one of my posts that the Master connection would request a "Transaction Clone" which would be a GUID that could be sent to another *process* to allow that process' connection to link to the "Master Transaction". > > Ad-hoc queries?!!??? Huh??? > > > > Where was I advocating Ad-Hoc queries? > > There: https://groups.yahoo.com/neo/groups/firebird- > support/conversations/topics/130409 > From that conversation I came to conclusion that your system don't use > prepared statements at all. I didn't say that the queries had to be ad-hoc. You can create as many prepared statements as is required for each combination of UPDATE you need, then use the statement that meets your need. So, you would have a "library" of prepared statements that you could execute in the most efficient manner possible. 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