Ann wrote

>At 03:23 PM 6/13/2001 +0100, Ray Drew wrote:
>>
>> I did not see in the docs that INT64 would vary its
>>storage requirements.... Will an INT64 compress a value of
>>32767 to 2 bytes? Or 255 to 1 byte?

>No, I picked the best case. The whole record is subject to run length
>compression. Any run of three or more identical bytes is compressed to
>two bytes, length and value. Any run of more than 128 identical bytes
>will require two length/value pairs.


>> >The datatype of a numeric value has no effect on indexing.
>>
>>So there's no performance benefit in using smaller keys?

>Not for numerics.

Bottom line... Would you recommend using Int64 for all generated pk values?

Regards,

Ray
CIA UK


[Non-text portions of this message have been removed]