View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000888 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2009-05-13 13:05 | 2012-12-07 13:59 |
| Reporter | rimvydas_paskevicius | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.1 revision 18442 | ||||
| Fixed in Version | 4.1.2 revision 18998 | ||||
| Summary | 0000888: Loading corsseling ajax list in admin takes a lot of time | ||||
| Description | In the admin user selects article->crossselling: the time for loading this page is too long so that the server exeeds a scipt break. Also if list apears, scollbar is not displayed if artiles count exeeds the limit. | ||||
| Tags | AJAX | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
|
|
The problem with slow loading crossselling in admin is realted with DB table oxobject2article. Adding additional index to field "oxobjectid" will significally reduces query time when loading ajax lists. Also there are problem with reporting correct articles amount to ajax list, so count query was updated. |
