|Subject||ODP: RE: [firebird-support] system table behaviour|
-------- Oryginalna wiadomość --------
Od: "'Andrew Zenz' andrew@... [firebird-support]" <firstname.lastname@example.org>
Data: 04.02.2016 05:55 (GMT+01:00)
Temat: RE: [firebird-support] system table behaviour
‘Tis starting to make some sense now.
Unfortunately our application establishes a connection to the FB server and remains active until shut down. I can’t terminate it and create a new one. A ‘feature’ of the RAD we are using.
You have given me an idea though, thanks.
Sent: Thursday, 4 February 2016 3:31 PM
Subject: Re: [firebird-support] system table behaviour
Thursday, February 4, 2016, 2:19:07 PM, you wrote:
You don't have to close the application to refresh the MON$ results,
simply commit the transaction and run the query in a new transaction.
The MON4 tables are in-memory structures. Queries on them run in a
SNAPSHOT transaction. That is, the statement provides a snapshot of
the status of those items at the time the transaction started and will
not be "refreshed" by re-running the same query inside the same
The persistent system tables (RDB$...) behave like any regular table.