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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024713
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] Y. DBSourceManagerminorhave not tried2013-09-06 12:242013-09-17 19:02
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version3.0MP28
StatusclosedFix in branchFixed in SCM revision7eada4720c21
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

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

- Issue History
Date Modified Username Field Change
2013-09-06 12:24 shuehner New Issue
2013-09-06 12:24 shuehner Assigned To => shuehner
2013-09-06 12:24 shuehner Modules => Core
2013-09-06 12:24 shuehner OBNetwork customer => No
2013-09-06 12:24 shuehner Triggers an Emergency Pack => No
2013-09-06 12:25 shuehner Review Assigned To => marvintm
2013-09-06 12:26 hgbot Checkin
2013-09-06 12:26 hgbot Note Added: 0060962
2013-09-10 17:55 hgbot Checkin
2013-09-10 17:55 hgbot Note Added: 0061060
2013-09-10 17:55 hgbot Status new => resolved
2013-09-10 17:55 hgbot Resolution open => fixed
2013-09-10 17:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7eada4720c21a0c4c25bba169f3ee225c815f447 [^]
2013-09-10 18:31 marvintm Status resolved => closed
2013-09-10 18:31 marvintm Fixed in Version => 3.0MP28
2013-09-17 19:02 hudsonbot Checkin
2013-09-17 19:02 hudsonbot Note Added: 0061234

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker