View Issue Details

IDProjectCategoryView StatusLast Update
0002423OXID eShop (all versions)4.05. Performancepublic2023-11-13 16:40
Reporterarvydas_vapsva Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status confirmedResolutionopen 
Product Version4.4.5 revision 31315 
Target Version8.0.0 
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
Attached Files
screenshot01.png (122,413 bytes)   
screenshot01.png (122,413 bytes)   
Theme
BrowserAll
PHP VersionNot defined
Database 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

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_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)