0002423: oxArticle::getStockCheckQuery() problem

ID	Project	Category	View Status	Date Submitted	Last Update

0002423	OXID eShop (all versions)	4.05. Performance	public	2011-01-20 10:52	2023-11-13 16:40

Reporter	arvydas_vapsva	Assigned To
Priority	normal	Severity	feature	Reproducibility	always
Status	confirmed	Resolution	open
Product Version	4.4.5 revision 31315
Target Version	8.0.0

Summary	0002423: oxArticle::getStockCheckQuery() problem
Description	When blUseStock ON, blVariantParentBuyable OFF oxArticle::getStockCheckQuery() builds SQL subquery which slows down product search
Steps To Reproduce	Create shop with huge amount of product + variants (50k), and go to search
Tags	MySQL, Performance, Products, SQL
Attached Files	screenshot01.png (122,413 bytes) screenshot01.png (122,413 bytes)

Theme
Browser	All
PHP Version	Not defined
Database Version	Not defined

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)