View Issue Details

IDProjectCategoryView StatusLast Update
0005551OXID eShop (all versions)4.01. Database handlingpublic2014-01-14 08:37
Reportermarco_steinhaeuser 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.8.1 / 5.1.1 
Target Version4.8.2 / 5.1.2Fixed in Version4.9.0_5.2.0_beta1 
Summary0005551: Index missing in oxnewssubscribed
DescriptionMissing index in oxnewssubscribed can lead to performance losses when querying this data base table.
Additional Informationinfo from Daniel Niedergesäß [syseleven]
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
MySQL Versionany

Activities

marco_steinhaeuser

2013-12-03 20:46

administrator   ~0009329

Amendment: SQL WHERE queries are used with this DB table

marco_steinhaeuser

2013-12-04 10:11

administrator   ~0009330

In order to fix this manually please use the following statement:
ALTER TABLE oxnewssubscribed add index(OXID);

vaidas.matulevicius

2014-01-14 08:37

reporter   ~0009413

Index was added for next major version. For older eShop versions can be used Marco suggested solution.