[TYPO3-english] Duplicate cHash values

[Mathias Schreiber [wmdb >]]

Dmitry Dulepov schrieb:
> Hi!
> 
> Mathias Schreiber [wmdb >] wrote:
>>> md5 provides uniqueness only if it is full 32-bit value. Using 16 bit
>>> will decrease probablity of conflict but will not eliminate it.
>> Why not use integers anyways?
> 
> Integer as a URL hash?

As far as cHash is concerned instead of doing an MD5 hash you could 
simply do CRC32() in mysql.
You use the hash just to look up the correct parameters from the table 
anyways.

Indexing should be fast enough with integers and might (not yet tested) 
outperform binary(16).

enjoy
Mattes