View Issue Details

IDProjectCategoryView StatusLast Update
0006875OXID eShop (all versions)4.01. Database handlingpublic2023-09-13 11:14
Reportertimwetter Assigned To 
PrioritylowSeverityfeatureReproducibilityalways
Status confirmedResolutionopen 
Product Version6.0.3 
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
Database VersionOther

Activities

SvenBrunk

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.