middasgoldtouch wrote:

>As I understand how BLOBs work, the data goes into a different table and there is
>an address pointing to that table in the record. Would this mean it

is possible

>to assign the same BLOB value to multiple records without adding the

BLOB data

>every time? If so, how is this done? Thanks in advance.

When wanting to share things, I think normalisation, in your case that
means that if the Blob appears on several records, then consider having
a separate table with the Blob and some ID field and then only store the
ID field in your main table. If the Blob is shared in five of a million
cases, it is not worth doing, but if a million records share a total of
five Blobs, then it is definitely worth it. Your case is probably
somewhere in between and it may or may not be sensible to do this.

Set