Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0043271 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] Y. DBSourceManager | minor | have not tried | 2020-02-19 17:29 | 2022-02-01 08:05 | ||||||
| Reporter | shuehner | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Merge Request Status | |||||||||||
| Review Assigned To | |||||||||||
| OBNetwork customer | No | ||||||||||
| 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. | ||||||||||
| Tags | Performance | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |