View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001808 | OXID eShop (all versions) | 4.05. Performance | public | 2010-04-30 18:28 | 2012-12-10 13:29 |
| Reporter | tomas_liubinas | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.4.3 revision 30016 | ||||
| Summary | 0001808: Suboptimal query for price select | ||||
| Description | There exists query: select count(oxarticles.oxid) from oxarticles where oxarticles.oxid in (select if( oxparentid='', oxid, oxparentid ) as id from oxarticles where oxprice >= 0 and oxprice <= 9.99 ) and oxarticles.oxissearch = 1 and ( oxarticles.oxactive = 1 ); In some shop it takes almost 30 secs to execute. Price selection could be optimised here a lot. | ||||
| Tags | Performance | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
