>Hi,
>
>i want compute
CDX Bloat ratio at runtime.
>
>Before search a solution:
>
>CDXBloatRatio=currentCDXFilesize/MinimalCDXFilesize-1
>
>*currentCDXFilesize is banal
>*MinimalCDXFilesize = GetCDXSize(TAGINFO(table),RECCOUNT(table))
>
>
>Somebody have the correct function GetCDXSize() ?
You might be able to create a temporary table with the same structure, APPEND all rows to it, then create the indices. This should give you the minimum CDX size.
This might even be achieved by something as simple as COPY TO ... WITH PRODUCTION, as long as it actually re-creates the indices in this case, rather than just copying the .CDX.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up