| 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 | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
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; |
|
|
Hi Arvydas, will this be fixed in 5.0.4? best regards, Mark |
|
|
Hi Arvydas, when will this Error be fixed? Is there some kind of schedule for this Issue? Sincerly, Jan-Ole Zürcher |
|
|
Hi, some Kind of Update for our customer? Sincerly, Jan-Ole Zürcher |
|
|
Someone fixing this error? Locks like no one cares about this Fix. |
|
|
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). |
