Openbravo Issue Tracking System - Retail Modules
View Issue Details
0056454Retail ModulesWeb POSpublic2024-09-16 10:432024-09-18 12:37
malsasua 
Retail 
highmajoralways
newopen 
5
 
 
No
0056454: Perfromance problem in incremental refresh process, with ProductCharacteristicValue model and Extended Assortment
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
. configure one environment with 1.2M of records in ProductCharacteristicValue
. configure it using Extended Assortment
No tags attached.
Issue History
2024-09-16 10:43malsasuaNew Issue
2024-09-16 10:43malsasuaAssigned To => Retail
2024-09-16 10:43malsasuaTriggers an Emergency Pack => No
2024-09-18 12:08jorgewederagoStatusnew => acknowledged
2024-09-18 12:23jorgewederagoStatusacknowledged => scheduled
2024-09-18 12:23jorgewederagoStatusscheduled => feedback
2024-09-18 12:23jorgewederagoStatusfeedback => new
2024-09-18 12:37marvintmNote Added: 0169313
2024-09-18 12:37marvintmTypedefect => design defect

Notes
(0169313)
marvintm   
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.