Notes |
|
(0038560)
|
hgbot
|
2011-06-28 15:37
|
|
Repository: erp/devel/pi
Changeset: e1d5f2393ed8deaae82b028ce879053d04108e5a
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Jun 28 14:07:26 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e1d5f2393ed8deaae82b028ce879053d04108e5a [^]
Fixed 17796, Fixed 17810: 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
---
|
|
|
(0038633)
|
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
---
|
|
|
(0038635)
|
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
---
|
|
|
|
|