21.08.2015 14:05, Jiří Činčura wrote: > > Is there a way to somewhat get a number of connections to given database > that's always (or in some predefined interval, known in advance) up to date? > Selecting from mon$attachments gets sometimes stale data even after few > seconds. Maybe there's some fixed interval I should wait - basically I found > that after 10+ seconds it's OK, but that's too long.
MON$ATTACHMENTS never returns stale data (provided you query it in a new transaction every time), unless you forced abnormal disconnection at the network layer and the server's TCP stack didn't yet discover the connection as lost. In this case Firebird considers the connection alive and there are no ways to count it as dead. Dmitry ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
