so using the digest doesn’t eliminate
>> the need to store the text. Anyway, is it better to keep primary keys small,
>> or is C* okay with large primary keys?
>>
>> Robert
>>
>
0’s of K’s in size. Would it be better to use a digest of the text as the
>> key? I have a background process that will occasionally need to do a full
>> table scan and retrieve all of the texts, so using the digest doesn’t
>> eliminate the need to store the text. Anyway, is it better to keep primary
>> keys small, or is C* okay with large primary keys?
>> >>
>> >> Robert
>> >>
>> >
>>
>>
be
> 10’s of K’s in size. Would it be better to use a digest of the text as the
> key? I have a background process that will occasionally need to do a full
> table scan and retrieve all of the texts, so using the digest doesn’t
> eliminate the need to store the text. Anyway, is it better to keep primary
> keys small, or is C* okay with large primary keys?
> >>
> >> Robert
> >>
> >
>
>
ieve all of the texts, so using the digest doesn’t eliminate
>> the need to store the text. Anyway, is it better to keep primary keys small,
>> or is C* okay with large primary keys?
>>
>> Robert
>>
>
texts, so using the digest doesn’t eliminate the need to
store the text. Anyway, is it better to keep primary keys small, or is C* okay
with large primary keys?
Robert
to use a digest of the text as the key?
> I have a background process that will occasionally need to do a full table
> scan and retrieve all of the texts, so using the digest doesn’t eliminate
> the need to store the text. Anyway, is it better to keep primary keys
> small, or is C* okay wi
While large primary keys (within reason) should work, IMO anytime you're
doing equality testing you are really better off minimizing the size of the
key. Huge primary keys will also have very negative impacts on your key
cache. I would err on the side of the digest, but I've never had
table scan and
retrieve all of the texts, so using the digest doesn’t eliminate the need to
store the text. Anyway, is it better to keep primary keys small, or is C* okay
with large primary keys?
Robert