View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0005379OXID eShop (all versions)4.07. Source code, Testpublic2013-08-30 09:492015-12-01 10:48
Reporterarvydas_vapsva 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.7.6 / 5.0.6 
Target VersionFixed in Version 
Summary0005379: oxArticleList and select * from does not employ lazy loading
DescriptionIn oxArticleList there are places in source code, where all fields are selected from oxarticles table, e.g. "select * from.." or "select $sArticleTable.* from...".

This should be optimized to e.g.:

"select ".$this->getBaseObject()->getSelectFields()." from ..."
TagsNo tags attached.
ThemeNot defined
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities

gpayer

2013-10-22 11:38

reporter   ~0009186

Alternatively lazy loading in objects inside an oxList could be activated. Currently there seems to be a problem with this. So if you don't know which fields you will need, you use selectString('select * from ...').
That's probably not the intended usage.