Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024713Openbravo ERPY. DBSourceManagerpublic2013-09-06 12:242013-09-17 19:02
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP28 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024713: Speed up create.database + import.sampledata by using more jdbc batching
DescriptionThe creation of foreign keys in create.database + the dropping/creation of check constraints in import.sample does not use jdbc batching.

Changing this to use batching gives a very nice performance boost.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-06 12:24shuehnerNew Issue
2013-09-06 12:24shuehnerAssigned To => shuehner
2013-09-06 12:24shuehnerModules => Core
2013-09-06 12:24shuehnerOBNetwork customer => No
2013-09-06 12:24shuehnerTriggers an Emergency Pack => No
2013-09-06 12:25shuehnerReview Assigned To => marvintm
2013-09-06 12:26hgbotCheckin
2013-09-06 12:26hgbotNote Added: 0060962
2013-09-10 17:55hgbotCheckin
2013-09-10 17:55hgbotNote Added: 0061060
2013-09-10 17:55hgbotStatusnew => resolved
2013-09-10 17:55hgbotResolutionopen => fixed
2013-09-10 17:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7eada4720c21a0c4c25bba169f3ee225c815f447 [^]
2013-09-10 18:31marvintmStatusresolved => closed
2013-09-10 18:31marvintmFixed in Version => 3.0MP28
2013-09-17 19:02hudsonbotCheckin
2013-09-17 19:02hudsonbotNote Added: 0061234

Notes
(0060962)
hgbot   
2013-09-06 12:26   
Repository: erp/devel/dbsm-main
Changeset: 621081475315e47fdd8f6dc58c99d32ea96620a1
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Sep 06 12:26:06 2013 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/621081475315e47fdd8f6dc58c99d32ea96620a1 [^]

Issue 24713: Speed up create.database & import.sampledata
Speed up those actions by using more jdbc batching for
creation of foreign keys and for drop/create of check constraints

---
M src/org/apache/ddlutils/platform/PlatformImplBase.java
---
(0061060)
hgbot   
2013-09-10 17:55   
Repository: erp/devel/pi
Changeset: 7eada4720c21a0c4c25bba169f3ee225c815f447
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 10 11:36:05 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7eada4720c21a0c4c25bba169f3ee225c815f447 [^]

Fixed 24682. Fixed 24713. Speed up install.source & update.database
Commit jar containing the fixed for those two issues

---
M src-db/database/lib/dbsourcemanager.jar
---
(0061234)
hudsonbot   
2013-09-17 19:02   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1c53d622fc50 [^]

Maturity status: Test