View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003433 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2011-12-14 10:01 | 2011-12-14 10:39 |
| Reporter | arvydas_vapsva | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.6 revision 40808 | ||||
| Fixed in Version | 4.5.6 revision 40808 | ||||
| Summary | 0003433: Inefficient code in oxNewsLetter::_assignProducts(), which slows down email sending | ||||
| Description | In oxNewsLetter::_assignProducts() there is a query: $sSelect = "select $sArticleTable.* from oxorder left join oxorderarticles on oxorderarticles.oxorderid = oxorder.oxid"; $sSelect .= " left join $sArticleTable on oxorderarticles.oxartid = $sArticleTable.oxid"; $sSelect .= " where ".$oArticle->getSqlActiveSnippet(); $sSelect .= " and oxorder.oxuserid = '".$this->_oUser->getId()."' order by oxorder.oxorderdate desc " and "limit 1" is missing here. Without it query may take long time on live shops with big amounts of data | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
