Subject | RE: [firebird-support] Readonly databases |
---|---|
Author | Alan McDonald |
Post date | 2008-08-26T06:20:43Z |
> fb_jamaa wrote:agreed - that's what it sounds like. But this should be improved such that no monitoring can take place when the DB is set readonly. (and thus no hanging behaviour).
> > The exception crops up when i access any of the MON$* tables, even
> with a
> > mere select statement, but not with other tables. Once i access the
> MON$*
> > tables, new attachments to the database hang, and a detach from the
> > database with the current client also hangs
>
> 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...
>
> Dean.
Alan