[TYPO3-english] Duplicate cHash values

[Dan Osipov]

But is the hash unique & fast for lookups?

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Dmitry Dulepov wrote:
> Hi!
> 
> Dmitry Martynenko wrote:
>> Now I have tx_realurl_chashcache table like (it differs from standart
>> RealURL table - spurl_hash already store full MD5 value):
>>
>> CREATE TABLE `tx_realurl_chashcache` (
>>   `spurl_hash` VARCHAR(32) NOT NULL DEFAULT '',
>>   `chash_string` VARCHAR(10) NOT NULL DEFAULT '',
>> )
>>
>> If extend chash_string to full MD5 it will be VARCHAR(32),
>> and each record will occupy 64 bytes.
>>
>> But if use BINARY(16) for both fields, then each record will occupy only 32 bytes.
> 
> Yes, it is possible.
>