TYPO3 Core

The ReferenceIndex table sys_refindex is heavily used to keep track of relations between all kind of rows from multiple tables.
The table sys_refindex stores thousands of rows to do its job.

It would be beneficial to keep sys_refindex rows and its indexes as small as possible.

hash column¶

• hash is generated as a 32 char long hex in string format e.g. 0123456789abcdef0123456789abcdef
• hash is stored as 32 char long utf8 string
• hash is the PRIAMRY KEY and becomes part of every index. (3 indexes in total right now).

Reduce size of hash¶

• A. store as binary: not feasable as tests cases are hard to implement and performance for BTREE is not the best.
• B. store with charset latin1: ext_tables.sql is not able to deal with charset restrictions on fieldlevel right now.

See dicussion on slack:
https://typo3.slack.com/archives/C03AM9R17/p1714293821710339

• C. convert from hex string to base64 string and store as 22 char long utf8 string: 16^32 < 64^22