Subject | Re: performance question |
---|---|
Author | Alexander V.Nevsky |
Post date | 2004-04-20T08:53:49Z |
--- In firebird-support@yahoogroups.com, Nick Upson <nick@u...> wrote:
RDB$RELATIONS table and affect tables only (old data is'nt touched
when table is altered and FORMAT mark is used to convert them to new
structure on the fly, so we can have 256 "generations" of the data
structure in the table before must do backup/restore). In old IB this
counter was erroneously incremented when triggers on the table were
altered too.
Best regards,
Alexander.
> I thought the 256 limit was for the entire database rahter than peritem (SP,
> table, etc), was it like that in FB1.0?No. In fact this counter is RDB$FORMAT SMALLINT column in
RDB$RELATIONS table and affect tables only (old data is'nt touched
when table is altered and FORMAT mark is used to convert them to new
structure on the fly, so we can have 256 "generations" of the data
structure in the table before must do backup/restore). In old IB this
counter was erroneously incremented when triggers on the table were
altered too.
Best regards,
Alexander.