I have several tables that contain RTF, DOC or text in compressed blobs. (Latest Ver 4).

As compression worksm more or less, but using redundancy to build trees, etc. Is each blob entry individually compressed? As these are programs for businesses, typically the blobs are
going to have many "talked to Client..." etc.

If the table is optimized, is the compression recalculated using the entire blob to create the redundancy lists/dictionaries?

I'm trying to determine if I should automate optimization to save space (space often important in these applications)

Thanks.

Herb (Kraft)

Herb,

<< As compression worksm more or less, but using redundancy to build trees,
etc. Is each blob entry individually compressed? >>

Yes.

<< If the table is optimized, is the compression recalculated using the
entire blob to create the redundancy lists/dictionaries? >>

Yes, but it won't change the compression one bit.   The organization of the
data on disk is separate from how the data is compressed prior to the
storage layer.

--
Tim Young
Elevate Software
www.elevatesoft.com