Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014035Openbravo ERP09. Financial managementpublic2010-07-22 16:032010-07-27 15:41
Reportershuehner 
Assigned Toshuehner 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014035: fact_acct_reset pl-function is too slow
DescriptionIn some use-cases this function is very slow.
Details in support ticket 8683
Steps To Reproduce
Proposed Solutiona.) add one missing index
b.) move some parts with constant results out of a query
Additional Information
TagsNo tags attached.
Relationships
related to defect 0014040 closed shuehner try-api-check 77 fails 
Attached Filesdiff 14035.diff (2,611) 2010-07-22 17:28
https://issues.openbravo.com/file_download.php?file_id=2795&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-07-22 16:03shuehnerNew Issue
2010-07-22 16:03shuehnerAssigned To => shuehner
2010-07-22 16:03shuehnerOBNetwork customer => No
2010-07-22 17:28shuehnerFile Added: 14035.diff
2010-07-23 13:51shuehnerRelationship addedrelated to 0014040
2010-07-23 13:52hgbotCheckin
2010-07-23 13:52hgbotNote Added: 0029534
2010-07-23 13:52hgbotStatusnew => resolved
2010-07-23 13:52hgbotResolutionopen => fixed
2010-07-23 13:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d7482229a1ec1ef64fe4d209f4e37b543c0db0d5 [^]
2010-07-26 13:35eduardo_ArgalStatusresolved => closed
2010-07-27 00:00anonymoussf_bug_id0 => 3034951
2010-07-27 15:41hudsonbotCheckin
2010-07-27 15:41hudsonbotNote Added: 0029606

Notes
(0029534)
hgbot   
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   
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 [^]