19.04.2017 22:10, Leyne, Sean wrote: > Again, you are thinking far too narrowly -- trying to define a problem to > convenience frame of reference.
Ok, let me think wider: tell me why you need to move whole tables to other server so often and so quickly? May be you'd better use continuous replication of changes instead of repeated transfer of whole tables? You said that there is no simple solution for your problems. It means that you tried something. Did you try to use of stored aggregates or any kind of OLAP? How about clustering, sharding or other way of horizontal scaling? > 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? > 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. -- 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