View Issue Details

IDProjectCategoryView StatusLast Update
0002678OXID eShop (all versions)4.05. Performancepublic2012-12-10 13:29
Reportermark Assigned To 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
Product Version4.4.7 revision 33396 
Fixed in Version4.5.1 revision 38045 
Summary0002678: Empty LongDescription results in multiple SQL-selects on product detail view
DescriptionoxArticle::getArticleLongDesc() loads the LongDescription. While it is empty, the next time getArticleLongDesc() is called, a new SQL-select is fired.
Additional InformationTo reduce SQL-selects on product detail view und increase performance please change line 2201 from

if (isset($this->oxarticles__oxlongdesc) && ($this->oxarticles__oxlongdesc instanceof oxField) && $this->oxarticles__oxlongdesc->value) {

to

if (isset($this->oxarticles__oxlongdesc) && ($this->oxarticles__oxlongdesc instanceof oxField)) {
TagsPerformance
Theme
BrowserAll
PHP Versionany
Database Versionany

Activities

dainius.bigelis

2011-04-08 14:05

reporter   ~0004342

@Developers: please check from the source code side, if such improvement is possible. If not - please write the comment here.

Linas Kukulskis

2011-04-19 15:00

reporter   ~0004373

in 4.5 oxArticle::getArticleLongDesc() is re-factored.