View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006810 | OXID eShop (all versions) | 4.01. Database handling | public | 2018-03-19 15:46 | 2018-03-20 09:13 |
| Reporter | henrik.steffen | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | unable to reproduce |
| Status | closed | Resolution | open | ||
| Product Version | 6.0.1 | ||||
| Summary | 0006810: Missing index for new field oxarticles.oxhidden | ||||
| Description | Makes query for "Newest articles" selection on shop startpage extremely slow when in automatic mode. | ||||
| Tags | No tags attached. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
The function ArticleList::loadNewestArticles() uses the views table which has no indexes at all. As a conclusion, the oxhidden field doesn't slowing down the page more than the other fields would do. I still tested the scenario and can't see any noticeable difference in speed while switching from manual to automatic mode. |
