Openbravo Issue Tracking System - Retail Modules | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0034982 | Retail Modules | StoreServer | public | 2017-01-17 16:22 | 2017-01-27 09:30 |
Reporter | AugustoMauch | ||||
Assigned To | AugustoMauch | ||||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | RR17Q2 | |||
Merge Request Status | |||||
Review Assigned To | mtaal | ||||
OBNetwork customer | |||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0034982: Improve the performance of the validate.store.data task | ||||
Description | The validate.store.data task does not have a good performance when validating stores in high volume environments. The current approach keeps caches of the data that is going to validate, which takes a lot of RAM to maintain and is very time consuming to process. A better approach is to detect the inconsistent data using SQL queries. For instance, if these two queries are used to export two tables: select * from table_A where where_clause_A select * from table_B where where_clause_B Then, if the table_A has a column name table_B_id that references table_B, the following query will return that inconsistent rows of table_A: select table_A_id from table_A as A left join table_B as B on A.table_B_id = B.table_B_id where where_clause_A and where_clause_B and A.table_B_id is not null and B.table_B_id is null This query is an adaptation of the query defined in this image [1], first column of second row. [1] https://i.stack.imgur.com/VQ5XP.png [^] | ||||
Steps To Reproduce | - | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2017-01-17 16:22 | AugustoMauch | New Issue | |||
2017-01-17 16:22 | AugustoMauch | Assigned To | => AugustoMauch | ||
2017-01-17 16:22 | AugustoMauch | Triggers an Emergency Pack | => No | ||
2017-01-18 13:28 | hgbot | Checkin | |||
2017-01-18 13:28 | hgbot | Note Added: 0093693 | |||
2017-01-18 13:28 | hgbot | Status | new => resolved | ||
2017-01-18 13:28 | hgbot | Resolution | open => fixed | ||
2017-01-18 13:28 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/963ec1086228a05164556a757b3ff39cf466c8d9 [^] | ||
2017-01-18 17:03 | mtaal | Review Assigned To | => mtaal | ||
2017-01-18 18:10 | AugustoMauch | Note Added: 0093712 | |||
2017-01-25 15:48 | hgbot | Checkin | |||
2017-01-25 15:48 | hgbot | Note Added: 0093822 | |||
2017-01-25 16:30 | hgbot | Checkin | |||
2017-01-25 16:30 | hgbot | Note Added: 0093825 | |||
2017-01-27 09:29 | hgbot | Checkin | |||
2017-01-27 09:29 | hgbot | Note Added: 0093865 | |||
2017-01-27 09:30 | mtaal | Note Added: 0093866 | |||
2017-01-27 09:30 | mtaal | Status | resolved => closed | ||
2017-01-27 09:30 | mtaal | Fixed in Version | => RR17Q2 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|