Releasing VC LOB space

After you upgrade to HCL Launch 7.0.5 and later, you can compress the amount of large object (LOB) storage space that HCL Launch uses in the vc_persistent_record database table.

Before you begin

Releasing the LOB storage space is optional. If you don't release the space, it is reused when new records are added. You can decide whether you want to release the LOB storage space for the following reasons:

  • You can reduce storage space by 75%.
    Reduce the size of one of the largest tables in HCL Launch where the text data decreases by 50-75%.
    • A 2-byte character to an average of 1-byte per UTF-8 character which is up to 50% reduction.
    • XML might compress by 87% or more because XML data contains many repeated keywords.
  • You can achieve up to a 50% reduction in read time.