Re: [Info-Ingres] Clob table compression

Thanks Karl,

We have CLOB tables that store large XML strings. For some reason I thought ingres compression
was based on the LWZ algorithm. Which is usually pretty good for text data.

Andre

-----Original Message-----
From: info-ingres-bounces-at-kettleriverconsulting.com [mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of Karl & Betty Schendel
Sent: October 2, 2008 8:28 AM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Clob table compression


On Oct 2, 2008, at 8:01 AM, Laframboise, André wrote:
>
>
> Does anyone know if data compression on a LOB table also compresses
> the iietab table ?
>

It appears that data compression is NOT applied to extension tables
under any circumstances. This kinda-sorta makes sense, given that
the current data compression only deals with trailing blanks. The
assumption would be that only the last LOB segment is likely to be
compressible, and unless LOB's are generally short, that is not a
significant percentage of the whole.

With a better compression method it might make more sense to allow
etab compression too.

Karl


_______________________________________________
Info-Ingres mailing list
Info-Ingres-at-kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres