View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003106 | OXID eShop (all versions) | 4.05. Performance | public | 2011-08-01 12:58 | 2012-12-10 13:29 |
| Reporter | webtools | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | 4.6.0_beta2 | ||||
| Summary | 0003106: Indizes in oxarticle etc. | ||||
| Description | Hi, watching the querys made for example within selects at the oxarticle-table, I found a performance improvement by creating an index over the field oxsoldamount. Setting an Index (localhost development environment) at this field i won several seconds. Before ca. 10 secondes, after 0,002 seconds "select * from oxv_oxarticles_de where ( oxv_oxarticles_de.oxactive = 1 ) and oxv_oxarticles_de.oxissearch = 1 and oxv_oxarticles_de.oxparentid = '' and oxv_oxarticles_de.oxsoldamount>0 order by oxv_oxarticles_de.oxsoldamount desc limit 5" This issue seems to be important within bigger article-tables up to 100.000 articles ;-) Perhaps it makes sense for you to check the indizes or for indixes which do not exist ;-) | ||||
| Tags | Performance | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
