View Issue Details

IDProjectCategoryView StatusLast Update
0006875OXID eShop (all versions)4.01. Database handlingpublic2023-09-13 11:14
Status confirmedResolutionopen 
Product Version6.0.3 
Target VersionFixed in Version 
Summary0006875: Primary key 32 bit long as Char(32) latain_
DescriptionWhy don't you use Binary(16) to store md5?
This is only 16bit long and together with other indizes in OXID DB you
will save more then a half of required space in ROM and RAM!!!
And this also will make OXID faster.

Any comments to this?

Kind Regards!
Additional Informationmysql 5.x or mysql 8.x
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionOther


Sven Brunk

2023-09-13 11:14

administrator   ~0015540

Hi Tim,

thank you for you recommendation. We have put this into our backlog.
As of now there are a lot of other possible improvements with more benefit in our backlog though.

Apart from that our assessment is, that this is a very risky BC break. So we will pick other things with less risk and higher reward earlier on.