Subject | Re: [firebird-support] Re: Images blobs in separate table |
---|---|
Author | Ivan Prenosil |
Post date | 2005-07-27T08:35:42Z |
>> 1. If the image files/blobs were stored separate from the data inWhen you update a row, but not it's blob, then the blob will not be duplicated.
>> their
>> own table, would there be an impact on overall database performance?
>
> Assuming that the images themselves were seldom modified after being
> inserted (which is probably the case), keeping the blobs in a
> different table would improve performance as modifying another field
> in a record would not require duplicating a BLOB.
Both old and new record versions will store the same blob-id.
Ivan
http://www.volny.cz/iprenosil/interbase/