Subject Re: [firebird-support] Readonly databases
Author Dmitry Yemanov
Alan McDonald wrote:

>> Just a guess, but I'd say that Firebird doesn't actually do any
>> monitoring until the first time you access a MON$ table, but once you
>> do, every time you log in/execute a statement/etc it has to update the
>> MON$ tables internally. If you've made the file read-only, it can't do
>> that...
>
> agreed - that's what it sounds like

No, that's wrong. The MON$ tables are never updated, even by the engine
itself.

The problem is related to blobs in the monitoring data. Nobody is
allowed to create blobs (even temporary ones) in a read-only database.
This is a historical limitation which has been removed in v2.5 only.


Dmitry