|Subject||Re: [firebird-support] Re: ON EXTERNAL DATA SOURCE|
On 02/03/2015 11:09, hvlad@... [firebird-support] wrote:
That's exactly the sort of opinion based on real experience of trying it that I was after, thanks.
a) if you really need to run hundreds or thousands queries per second against external
database i'd say you have a problems with design\architecture, sorry
Ah! - you're saying that a workaround to AUTONOMOUS closing the connection is to perform a do-nothing COMMON statement first, and then do the AUTONOMOUS ones. Yes, one can deduce that from the documentation, but it hardly makes it clear that this is a deliberate feature! - and I must say it does rather look slightly more like an accident of implementation than a deliberate feature to me.
b) you still don't read docs carefully: just run any query against external db using COMMON
transaction and all your subsequent external queries against same external db will use the
same external connection (for both COMMON and AUTONOMOUS tx). Until local transaction
alive, of course.
-- Tim Ward