Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017809
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] Y. DBSourceManagerminorhave not tried2011-06-27 18:332011-07-13 11:54
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision97f5209c1da6
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017809: '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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00177963.0MP1 closedshuehner 'Reading tables' on oracle is really slow but could be easily made 40s-2min faster 

-  Notes
(0038634)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2011-06-28 13:47 shuehner Type defect => backport
2011-06-28 13:47 shuehner fix_in_branch => 2.50
2011-06-30 15:48 hgbot Checkin
2011-06-30 15:48 hgbot Note Added: 0038634
2011-06-30 15:48 hgbot Checkin
2011-06-30 15:48 hgbot Note Added: 0038636
2011-07-01 18:30 marvintm Note Added: 0038694
2011-07-01 18:30 marvintm Status scheduled => resolved
2011-07-01 18:30 marvintm Fixed in SCM revision => 9541
2011-07-01 18:30 marvintm Resolution open => fixed
2011-07-01 18:30 marvintm Status resolved => closed
2011-07-04 13:26 hgbot Checkin
2011-07-04 13:26 hgbot Note Added: 0038743
2011-07-04 13:26 hgbot Status closed => resolved
2011-07-04 13:26 hgbot Fixed in SCM revision 9541 => http://code.openbravo.com/erp/stable/2.50/rev/97f5209c1da61cee36615837f7fd8e57a312fc0d [^]
2011-07-13 11:54 marvintm Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker