#103779Reduce size of hash in database for ReferenceIndex sys_refindex
Description
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
hashis generated as a 32 char long hex in string format e.g.0123456789abcdef0123456789abcdefhashis stored as 32 char long utf8 stringhashis thePRIAMRY KEYand 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 forBTREEis 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