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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014035
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorhave not tried2010-07-22 16:032010-07-27 15:41
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiond7482229a1ec
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014035: fact_acct_reset pl-function is too slow

DescriptionIn some use-cases this function is very slow.
Details in support ticket 8683
Proposed Solutiona.) add one missing index
b.) move some parts with constant results out of a query
TagsNo tags attached.
Attached Filesdiff file icon 14035.diff [^] (2,611 bytes) 2010-07-22 17:28 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0014040 closedshuehner try-api-check 77 fails 

-  Notes
(0029534)
hgbot (developer)
2010-07-23 13:52

Repository: erp/devel/pi
Changeset: d7482229a1ec1ef64fe4d209f4e37b543c0db0d5
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jul 22 16:05:00 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d7482229a1ec1ef64fe4d209f4e37b543c0db0d5 [^]

Fixed 14035: fact_acct_reset is too slow
Speed up this pl-function by:
- add missing index to c_periodcontrol table
- move one function call out of a complex query as it does not depend on any
  data from the query, instead execute the function onces before the bigger
  query.

---
M src-db/database/model/functions/FACT_ACCT_RESET.xml
M src-db/database/model/tables/C_PERIODCONTROL.xml
---
(0029606)
hudsonbot (developer)
2010-07-27 15:41

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d7482229a1ec [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/634cc0909ed2 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17922.obx [^]

- Issue History
Date Modified Username Field Change
2010-07-22 16:03 shuehner New Issue
2010-07-22 16:03 shuehner Assigned To => shuehner
2010-07-22 17:28 shuehner File Added: 14035.diff
2010-07-23 13:51 shuehner Relationship added related to 0014040
2010-07-23 13:52 hgbot Checkin
2010-07-23 13:52 hgbot Note Added: 0029534
2010-07-23 13:52 hgbot Status new => resolved
2010-07-23 13:52 hgbot Resolution open => fixed
2010-07-23 13:52 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d7482229a1ec1ef64fe4d209f4e37b543c0db0d5 [^]
2010-07-26 13:35 eduardo_Argal Status resolved => closed
2010-07-27 00:00 anonymous sf_bug_id 0 => 3034951
2010-07-27 15:41 hudsonbot Checkin
2010-07-27 15:41 hudsonbot Note Added: 0029606


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker