View Issue Details

IDProjectCategoryView StatusLast Update
0005379OXID eShop (all versions)4.07. Source code, Testpublic2023-11-21 09:19
Reporterarvydas_vapsva Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version4.7.6 / 5.0.6 
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.

SvenBrunk

2023-11-21 09:19

administrator   ~0015868

This is now the default way how it is done since many years. I only found 2 places in the core, where * is used and those were very specific cases, where it makes sense.