Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0056454 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Retail Modules] Web POS | major | always | 2024-09-16 10:43 | 2024-09-18 12:37 | |||||||
| Reporter | malsasua | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0056454: Perfromance problem in incremental refresh process, with ProductCharacteristicValue model and Extended Assortment | |||||||||||
| Description | In one environment with 1.2M records in characteristic value table, and using Extended Assortment , the incremental refresh is taking a long time If Extended Assortment field is set to empty, the problem is solved | |||||||||||
| Steps To Reproduce | . configure one environment with 1.2M of records in ProductCharacteristicValue . configure it using Extended Assortment | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0169313) marvintm (manager) 2024-09-18 12:37 |
We are changing this issue to design defect. The main reason is that the changes required in the query and the data model are most probably complex, and they should be considered a project instead of just a bug fix. We strongly encourage to review the data definition, as having a very large amount of disabled characteristic values doesn't seem to make much sense. A very simple way to avoid the problem would be to just delete those disabled characteristic values. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-09-16 10:43 | malsasua | New Issue | |
| 2024-09-16 10:43 | malsasua | Assigned To | => Retail |
| 2024-09-16 10:43 | malsasua | Triggers an Emergency Pack | => No |
| 2024-09-18 12:08 | jorgewederago | Status | new => acknowledged |
| 2024-09-18 12:23 | jorgewederago | Status | acknowledged => scheduled |
| 2024-09-18 12:23 | jorgewederago | Status | scheduled => feedback |
| 2024-09-18 12:23 | jorgewederago | Status | feedback => new |
| 2024-09-18 12:37 | marvintm | Note Added: 0169313 | |
| 2024-09-18 12:37 | marvintm | Type | defect => design defect |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |