Subject Re: [firebird-support] Re: Documental management systems.
Author Ann W. Harrison
Adam wrote:
>
> Embedding the files in a blob
> ...
> Cons:
>...
> If you do not manage your transactions, MGA may leave you with a
> database many times (even 100's of times) larger than the raw data.
> You will need to select the segment size a bit scientifically so you
> don't waste database pages.

Just in case there's confusion, Firebird does not create multiple copies
of blobs unless the blob itself changes. If other fields are modified,
all the record versions will reference the same copy of the blob.

Regards,


Ann