[TYPO3-dev] improve "alias" indices on UTF8 sites

Steffen Kamper steffen at dislabs.de
Mon Dec 4 13:57:45 CET 2006


Hi Masi,

"Martin Kutschker" <Martin.Kutschker at n0spam-blackbox.net> schrieb im 
Newsbeitrag 
news:mailman.1.1165235593.14398.typo3-dev at lists.netfielders.de...
> Hi!
>
> Some fields used for indices (eg aliases etc) are known to take only 
> 7bit-singlebyte data, yet Mysql has to deal with potentially 
> 8bit-multibyte data. Do you think that Mysql will access the indices more 
> efficient if these fields were marked as latin1? I think it may use less 
> memory for buffers etc.
>
> Masi

is it possible that you think of the 7-byte roll-pointer, which is an 
additional field of MySQL ?
Do you have a link that describes your technical point ?

vg Steffen 






More information about the TYPO3-dev mailing list