Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036180Openbravo ERP09. Financial managementpublic2017-06-06 09:362017-06-08 17:12
Reportereduardo_Argal 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036180: Add Multiple payments pick and execute performance
Descriptionwhen using Add multiple payments the resultant query when unfolding BP filter combo box is extreamly slow.
The problem seems to be related to the usage of AD_ISORGINCLUDED function
Steps To Reproduce1) Move to Financial account window
2) open add multiple payments P&E
3) move to BP column and unfold the combo box
4) realize the query is performing awfully
Proposed SolutionInstead of using ad_isorgincluded function, try to make a join to AD_Org_Tree table. This was proben to improve performance
Additional Information
TagsNo tags attached.
Relationships
depends on feature request 00355903.0PR17Q3 closed vmromanos AD_IsOrgIncluded performance improvements 
related to defect 0038551 closed AtulOpenbravo Improve performance of Add Multiple Payments process in Financial Account window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-06 09:36eduardo_ArgalNew Issue
2017-06-06 09:36eduardo_ArgalAssigned To => Triage Finance
2017-06-06 09:36eduardo_ArgalModules => Core
2017-06-06 09:36eduardo_ArgalTriggers an Emergency Pack => No
2017-06-06 10:15aferrazResolution time => 1498514400
2017-06-06 10:24aferrazAssigned ToTriage Finance => markmm82
2017-06-06 16:04markmm82Statusnew => scheduled
2017-06-07 12:21aferrazRelationship addeddepends on 0035590
2017-06-08 11:34hgbotCheckin
2017-06-08 11:34hgbotNote Added: 0097206
2017-06-08 11:34hgbotStatusscheduled => resolved
2017-06-08 11:34hgbotResolutionopen => fixed
2017-06-08 11:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/74b0fb916b1f87e67a865f097f035909aaa7c968 [^]
2017-06-08 11:46aferrazReview Assigned To => aferraz
2017-06-08 11:46aferrazNote Added: 0097210
2017-06-08 11:46aferrazStatusresolved => closed
2017-06-08 11:46aferrazFixed in Version => 3.0PR17Q3
2017-06-08 17:12hudsonbotCheckin
2017-06-08 17:12hudsonbotNote Added: 0097248
2018-05-17 09:22vmromanosRelationship addedrelated to 0038551

Notes
(0097206)
hgbot   
2017-06-08 11:34   
Repository: erp/devel/pi
Changeset: 74b0fb916b1f87e67a865f097f035909aaa7c968
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jun 06 17:05:14 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/74b0fb916b1f87e67a865f097f035909aaa7c968 [^]

Fixes issue 36180: Add Multiple payments pick and execute performance

When the BP filter combo box of Add multiple payments P&E the resultant query is
slow. The problem is related to the usage of AD_ISORGINCLUDED function.

To avoid it, and improve the performance, was used an EXISTS clause in the AD_ORG_TREE
table instead of using AD_ISORGINCLUDED function.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
---
(0097210)
aferraz   
2017-06-08 11:46   
Code review + Testing OK
(0097248)
hudsonbot   
2017-06-08 17:12   
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/fda0f16ab470 [^]
Maturity status: Test