Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0043271 | Openbravo ERP | Y. DBSourceManager | public | 2020-02-19 17:29 | 2022-02-01 08:05 |
| Reporter | shuehner | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | acknowledged | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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 | 0043271: create.database is not using multiple thread for function standardization | ||||
| Description | dbsourcemanager code is using multiple thread for the heavy function & trigger standardization. However that seems to be missing for the create.database code which seemingly is still single-threaded for this part: update.database output: [java] 10093 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Starting function trigger and view standardization in 4 threads [java] 15314 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Standardidized 299 functions, 319 triggers and 47 views in 5222 ms install.source: [createdatabase] 10279 [main] INFO org.openbravo.ddlutils.task.CreateDatabase - for the complete database [createdatabase] 77022 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Finished preparing SQL Can also be seen checking live during that part with top that only a single core is utilized. | ||||
| Steps To Reproduce | run install.source and check cpu usage during the part just before 'finished preparing SQL' | ||||
| Proposed Solution | Use same logic update.db + export.db already have. | ||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2020-02-19 17:29 | shuehner | New Issue | |||
| 2020-02-19 17:29 | shuehner | Assigned To | => platform | ||
| 2020-02-19 17:29 | shuehner | Modules | => Core | ||
| 2020-02-19 17:29 | shuehner | Triggers an Emergency Pack | => No | ||
| 2020-02-21 09:23 | alostale | Severity | major => minor | ||
| 2020-02-21 09:23 | alostale | Status | new => acknowledged | ||
| 2020-02-21 09:23 | alostale | Tag Attached: Performance | |||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |