View Issue Details

IDProjectCategoryView StatusLast Update
0004997OXID eShop (all versions)4.05. Performancepublic2013-04-09 13:22
Reporterarvydas_vapsva Assigned To 
Status resolvedResolutionfixed 
Product Version4.7.4 / 5.0.4 revision 57063 
Target Version4.7.4 / 5.0.4 revision 57063Fixed in Version4.7.5 / 5.0.5 
Summary0004997: Performacne unfriendly oxView::getCacheLifeTime()
Descriptionat least indexes to oxarticles::oxactivefrom should be added (oxfield2shop should also be treated), but in better case, this value should be stored somewhere when changed (e.g. on oxarticle save), but not queried through all table
TagsNo tags attached.
PHP Versionany
Database Versionany



2013-04-09 13:22

reporter   ~0008582

oxView::getCacheLifeTime() fix added in 5.0 patch and next major version.
Indexes added only next major version. So indexes to "oxactivefrom" and "oxfield2shop" you should add manually.