[TYPO3-english] Duplicate cHash values

[Dmitry Dulepov]

Hi!

Dmitry Martynenko wrote:
> But I think it is axiom: less data and shorter keys -> more speed to SELECT.

Less data and good keys for executed queries -> more speed to SELECT. Just making keys short will not improve speed. If there are a lot of records and key is partial. MySQL will search data instead of keys, which is slower.

-- 
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")