View Issue Details

IDProjectCategoryView StatusLast Update
0006875OXID eShop (all versions)4.01. Database handlingpublic2022-02-02 13:32
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


There are no notes attached to this issue.