Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017809Openbravo ERPY. DBSourceManagerpublic2011-06-27 18:332011-07-13 11:54
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017809: 'Reading tables' on oracle is really slow but could be easily made 40s-2min faster
DescriptionCan be done by restructuring the queries done for that part to remove two extra joins from the query execute for every foreign key.
Steps To Reproducen/a
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00177963.0MP1 closed shuehner 'Reading tables' on oracle is really slow but could be easily made 40s-2min faster 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-28 13:47shuehnerTypedefect => backport
2011-06-28 13:47shuehnerfix_in_branch => 2.50
2011-06-30 15:48hgbotCheckin
2011-06-30 15:48hgbotNote Added: 0038634
2011-06-30 15:48hgbotCheckin
2011-06-30 15:48hgbotNote Added: 0038636
2011-07-01 18:30marvintmNote Added: 0038694
2011-07-01 18:30marvintmStatusscheduled => resolved
2011-07-01 18:30marvintmFixed in SCM revision => 9541
2011-07-01 18:30marvintmResolutionopen => fixed
2011-07-01 18:30marvintmStatusresolved => closed
2011-07-04 13:26hgbotCheckin
2011-07-04 13:26hgbotNote Added: 0038743
2011-07-04 13:26hgbotStatusclosed => resolved
2011-07-04 13:26hgbotFixed in SCM revision9541 => http://code.openbravo.com/erp/stable/2.50/rev/97f5209c1da61cee36615837f7fd8e57a312fc0d [^]
2011-07-13 11:54marvintmStatusresolved => closed

Notes
(0038634)
hgbot   
2011-06-30 15:48   
Repository: erp/devel/dbsm-main
Changeset: 39b6a17e27864f2865292f3e3ccb6cb1cd587570
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 27 18:06:47 2011 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/39b6a17e27864f2865292f3e3ccb6cb1cd587570 [^]

Issue 17796, issue 17809: Refactor building sql string for list-foreign keys
 in OracleModelLoader to not duplicate the main/common part three times.

---
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
---
(0038636)
hgbot   
2011-06-30 15:48   
Repository: erp/devel/dbsm-main
Changeset: 7732acb54a35dfa314592da015b360cb19f93570
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 27 18:47:29 2011 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/7732acb54a35dfa314592da015b360cb19f93570 [^]

Issue 17796, issue 17809: Improve 'Reading tables' performance for oracle
Saves some 40s-2min depending on environment/system.
Done by creating overloaded version of readForeignKey used on oracle which
returns more information in the one select reading the list of all foreign-keys
in the database but then can skip doing 2 more in the sql executed per each
foreign key making those 2nd phase queries much faster.

---
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
---
(0038694)
marvintm   
2011-07-01 18:30   
As the dbsourcemanager .jar was committed to the 2.50 branch after this commit was done, it already includes this fix.
(0038743)
hgbot   
2011-07-04 13:26   
Repository: erp/stable/2.50
Changeset: 97f5209c1da61cee36615837f7fd8e57a312fc0d
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Jun 28 15:48:27 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/97f5209c1da61cee36615837f7fd8e57a312fc0d [^]

Fixed 17809, Fixed 17811: Speed up model loading
- part one: read tables on oracle faster
- part two: function/trigger standardization on pgsql faster

---
M src-db/database/lib/dbsourcemanager.jar
---