Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0043247 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2020-02-18 10:42 | 2022-04-21 15:48 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | PR22Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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 | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0135378) alostale (manager) 2022-03-02 10:48 |
It can be reproduced during install.source only. Subsequent translation imports work faster: install.source importTrl - Updated=2785 - from file AD_ELEMENT_TRL_es_ES.xml - time: 339855ms apply.module importTrl - Updated=2785 - from file AD_ELEMENT_TRL_es_ES.xml - time: 2054ms |
|
(0135382) hgbot (developer) 2022-03-02 12:02 |
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/535 [^] |
|
(0136668) hgbot (developer) 2022-04-21 15:36 |
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/535 [^] |
|
(0136669) hgbot (developer) 2022-04-21 15:36 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/openbravo [^] Changeset: ff16d4fee397f2c64d96b99e1ff5b779cedca66c Author: Asier Lostalé <asier.lostale@openbravo.com> Date: 21-04-2022 15:26:21 URL: https://gitlab.com/openbravo/product/openbravo/-/commit/ff16d4fee397f2c64d96b99e1ff5b779cedca66c [^] fixes BUG-43247: slow translation import for AD_ELEMENT in Oracle Importing translations in Oracle for AD_ELEMENT, specially during install.source is very slow. One of the biggest problem is, at this stage, DB statistics were outdated, updating them before importing translations reduces considerably the executiong time. The statistics update is only done on oracle where the speedup is considerable. --- M src/org/openbravo/erpCommon/modules/ApplyModule.java --- |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |