View Issue Details

IDProjectCategoryView StatusLast Update
0002423OXID eShop (all versions)4.05. Performancepublic2018-06-14 15:21
Reporterarvydas_vapsva 
PrioritynormalSeveritymajorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version4.4.5 revision 31315 
Target VersionFixed in Version 
Summary0002423: oxArticle::getStockCheckQuery() problem
DescriptionWhen blUseStock ON, blVariantParentBuyable OFF oxArticle::getStockCheckQuery() builds SQL subquery which slows down product search
Steps To ReproduceCreate shop with huge amount of product + variants (50k), and go to search
TagsMySQL, Performance, Products, SQL
ThemeAzure
BrowserAll
PHP VersionNot defined
MySQL VersionNot defined

Relationships

has duplicate 0006576 closedQA oxArticle::getStockCheckQuery() problem 

Activities

arvydas_vapsva

2011-01-20 11:06

reporter   ~0003998

Last edited: 2011-01-20 11:07

View 2 revisions

Solution:
- eliminate subquery from oxArticle::getStockCheckQuery();
- change oxstockcount calculation:
  
    in case any variant has oxstockflag "1"/"4"/"3": oxstockcount = 9999;
    in case all variants has oxstockflag "2": oxstockcount count must be preciselly calculated and monitored;

mark

2013-02-13 08:49

reporter   ~0008404

Hi Arvydas,

will this be fixed in 5.0.4?

best regards, Mark

wmdk_jozuercher

2017-01-24 12:40

reporter   ~0011944

Hi Arvydas,

when will this Error be fixed? Is there some kind of schedule for this Issue?

Sincerly,
Jan-Ole Zürcher

wmdk_dkussin

2017-01-24 12:49

reporter  

screenshot01.png (122,413 bytes)
screenshot01.png (122,413 bytes)

wmdk_jozuercher

2017-01-25 13:49

reporter   ~0011948

Hi,

some Kind of Update for our customer?

Sincerly,
Jan-Ole Zürcher

wmdk_jozuercher

2017-02-27 17:08

reporter   ~0011983

Someone fixing this error? Locks like no one cares about this Fix.

wmdk_dkussin

2018-06-14 15:21

reporter   ~0012510

Leider musste ich soeben feststellen, dass der Bug auch in OXID PE 6.0.2 nicht behoben wurde, so dass weiterhin der Workaround von arvydas_vapsva eingesetzt werden muss/kann.

Hier ein Update für OXID 6:
In der /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php die Funktion getStockCheckQuery() suchen (ca. Zeile 599) und den Inhalt der Funktion gegen return ""; tauschen (vgl. Screenshot).

screenshot01-2.PNG (23,253 bytes)
screenshot01-2.PNG (23,253 bytes)