View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002127 | OXID eShop (all versions) | 2. ----- eShop backend (admin) ----- | public | 2010-09-23 18:00 | 2012-12-07 13:59 |
| Reporter | d3 | Assigned To | |||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.4.2 revision 29492 | ||||
| Fixed in Version | 4.4.5 revision 31315 | ||||
| Summary | 0002127: shipping cost rules: query time - increases exponentially | ||||
| Description | Shop Settings / Shipping Cost Rules / Products /-> Assign Products The more articles you assign to a "shipping cost rule", the more time is needed for this query execute(Ajax List is loading): SELECT count( * ) FROM oxarticles WHERE 1 AND oxarticles.oxparentid = '' AND oxarticles.oxid NOT IN ( SELECT oxarticles.oxid FROM oxobject2delivery LEFT JOIN oxarticles ON oxarticles.oxid = oxobject2delivery.oxobjectid WHERE oxobject2delivery.oxdeliveryid = "286463b824829f5e8.06658778" AND oxobject2delivery.oxtype = "oxarticles" ) | ||||
| Steps To Reproduce | - I got a dump from a customer with 0000154:0000100.000 articles. - I assigned 1520 (oxobject2delivery / incl. variants) articles to a "shipping cost rule" - I reopened the Ajax List ( now it is time to wait ). - On the MySQL server you can see, with "SHOW PROCESSLIST;", what the query does: it produces 108710 rows in the result set (41 min 34.68 sec) - Second try with a new db. 0000011:0000046.087 articles and 853 assigned articles (no variants): i cancled after 3403 seconds | ||||
| Tags | AJAX | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
| related to | 0001565 | resolved | alfonsas_cirtautas | Only 2500 items will be displayed in Ajax lists |
| related to | 0002152 | resolved | arvydas_vapsva | AJAX lists are almost unusable when there are lot of products |
|
|
the numbers are: 0000154:0000100.000 = 100000 0000011:0000046.087 = 46087 |
|
|
I assigned about 200 articles and when opened AJAX list, needed to wait about 2 minutes with status "Loading..." (in the product list frames). So this place should be fixed, because when more items are assigned - it is not usable at all. |
|
|
fixed |
