View Issue Details

IDProjectCategoryView StatusLast Update
0006875OXID eShop (all versions)4.01. Database handlingpublic2018-08-06 15:25
Reportertimwetter 
PrioritylowSeverityfeatureReproducibilityalways
Status acknowledgedResolutionopen 
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!
Tim
Additional Informationmysql 5.x or mysql 8.x
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionOther

Activities

There are no notes attached to this issue.