Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0043247 | Openbravo ERP | A. Platform | public | 2020-02-18 10:42 | 2022-04-21 15:48 | |||||||
| Reporter | shuehner | |||||||||||
| Assigned To | alostale | |||||||||||
| Priority | urgent | Severity | minor | Reproducibility | have not tried | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | PR22Q3 | ||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0043247: Importing translation for table AD_ELEMENT_TRL takes huge amount of time (especially on oracle) | |||||||||||
| Description | Importing a translation takes a long time for the AD_ELEMENT_TRL table. Below is example output of a CI job importing french translation. Times left are milliseconds. On Postgres around 10s are needed to import 2660 rows On Oracle around 5minutes are needed PG 38679 importTrl - Updated=0 - from file AD_ALERTRULE_TRL_fr_FR.xml 47023 importTrl - Updated=2660 - from file AD_ELEMENT_TRL_fr_FR.xml ORA 533789 importTrl - Updated=0 - from file AD_ALERTRULE_TRL_fr_FR.xml 886177 importTrl - Updated=2660 - from file AD_ELEMENT_TRL_fr_FR.xml Especially in CI jobs having >1 translation pack as used by some customers that makes quick a big total slowdown of the oracle version: Install.source total time: PG: Total time: 5 minutes 35 seconds ORA: Total time: 23 minutes 1 second Likely cause is the trigger ad_element_trl_trg or obuiapp_element_trl_trg, obuisel_element_trl_trg as those are updating many other tables based on the newly imported/updated data. | |||||||||||
| Steps To Reproduce | install.source especially on oracle of i.e. french translation pack. Probably can be reproduced easier by only importing a single xml translation file for AD_ELEMENT_TRL | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | Performance | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2020-02-18 10:42 | shuehner | New Issue | ||||||||||
| 2020-02-18 10:42 | shuehner | Assigned To | => platform | |||||||||
| 2020-02-18 10:42 | shuehner | Modules | => Core | |||||||||
| 2020-02-18 10:42 | shuehner | Triggers an Emergency Pack | => No | |||||||||
| 2020-02-21 09:24 | alostale | Severity | major => minor | |||||||||
| 2020-02-21 09:24 | alostale | Status | new => acknowledged | |||||||||
| 2020-02-21 09:24 | alostale | Tag Attached: Performance | ||||||||||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | |||||||||
| 2022-03-01 07:10 | alostale | Priority | normal => urgent | |||||||||
| 2022-03-02 10:48 | alostale | Note Added: 0135378 | ||||||||||
| 2022-03-02 10:48 | alostale | Relationship added | related to 0032119 | |||||||||
| 2022-03-02 12:02 | hgbot | Note Added: 0135382 | ||||||||||
| 2022-04-21 15:36 | hgbot | Resolution | open => fixed | |||||||||
| 2022-04-21 15:36 | hgbot | Status | acknowledged => closed | |||||||||
| 2022-04-21 15:36 | hgbot | Note Added: 0136668 | ||||||||||
| 2022-04-21 15:36 | hgbot | Fixed in Version | => PR22Q3 | |||||||||
| 2022-04-21 15:36 | hgbot | Note Added: 0136669 | ||||||||||
| 2022-04-21 15:48 | alostale | Assigned To | Triage Platform Base => alostale | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||