>>>>> "Bill" == Bill Koob <wkoob@stripped> writes:
Bill> Vivek Khera wrote:
Bill> buy 10 licenses to get pack_isam. I just had to by
>> the extended support option. Believe me, the pack_isam program is
>> *well* worth that low, low, price. It has made one of our services
>> (which is a very complex database) run extremely fast by reducing the
>> disk seeks.
>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>> Vivek Khera, Ph.D. Khera Communications, Inc.
Bill> Sorry if this question has been asked before, but
Bill> what is the approximate savings on diskspace on a
Bill> typical file that pkzip will compress in the 80% - 85% range?
In cases like above, pack_isam typically gives you a compression of
50-70 %.
The difference between pkzip, compressed drives versus a table packed
with pack_isam is that all rows can be accessed directly; There is no
extra overhead to access any row in the table.
Regards,
Monty