[TYPO3-english] Duplicate cHash values
Dmitry Dulepov
dmitry at typo3.org
Mon Jan 19 14:21:43 CET 2009
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.
--
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")
More information about the TYPO3-english
mailing list