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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021944
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-10-16 10:122012-10-16 16:42
ReporteregoitzView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0MP18
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP16SCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021944: The modulescript UpdateRecordId2Value takes long to be executed having many values

DescriptionThe modulescript UpdateRecordId2Value takes long to be executed having many values.
The update of the modulescript is execute in every update what it is not needed if it has been previously executed.

Steps To Reproduce-ON an environment with the 358650 rows on the fact_acct and 22138 rows on the c_dept_payment table execute an update.database
-It takes too much to finish. Many of the time is spent on the UpdateRecordId2Value modulescript.
Proposed SolutionReplace that update on the thile modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/UpdateRecordId2Value_data.xsql


UPDATE FACT_ACCT SET RECORD_ID2 = NULL
        WHERE NOT EXISTS (SELECT 1 FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT_ID = RECORD_ID2)

with

UPDATE FACT_ACCT SET RECORD_ID2 = NULL
        WHERE NOT EXISTS (SELECT 1 FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT_ID = RECORD_ID2) AND RECORD_ID2 IS NOT NULL
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0021909 closededuardo_Argal ModuleScript UpdateRecordID2Value can take a very long time, every time it is ran 

-  Notes
(0053376)
dmiguelez (developer)
2012-10-16 16:42

 Issue already reported.

- Issue History
Date Modified Username Field Change
2012-10-16 10:12 egoitz New Issue
2012-10-16 10:12 egoitz Assigned To => dmiguelez
2012-10-16 10:12 egoitz Modules => Advanced Payables and Receivables Mngmt
2012-10-16 10:12 egoitz Resolution time => 1352502000
2012-10-16 12:13 egoitz Issue Monitored: networkb
2012-10-16 16:42 dmiguelez Relationship added duplicate of 0021909
2012-10-16 16:42 dmiguelez Note Added: 0053376
2012-10-16 16:42 dmiguelez Status new => closed
2012-10-16 16:42 dmiguelez Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker