Subject | Re: [firebird-support] Re: nbackup / gbak interoperation |
---|---|
Author | MagnOz |
Post date | 2009-12-15T01:42:50Z |
On Tue, Dec 15, 2009 at 01:34, dkeith2 <dkeith2@...> wrote:
pages once there is no current transaction which can see old record
versions stored on that page. This means it is best if your
transactions are active only for a short duration. Long running
transactions will block garbage collection.
> Are you saying that this is no longer an issue? Can a Firebird db be used in an OLTP scenario without performance degradation due to db page 'fragmentation' (again, for lack of a better term)?There's no fragmentation. But be aware that Firebird can only reclaim
pages once there is no current transaction which can see old record
versions stored on that page. This means it is best if your
transactions are active only for a short duration. Long running
transactions will block garbage collection.