Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 03. Procurement managementmajoralways2018-01-29 09:412018-01-31 08:48
ReporteregoitzView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version3.0PR18Q2
StatusclosedFix in branchFixed in SCM revision018323fa0ae3
ProjectionnoneETAnoneTarget Version3.0PR17Q4.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0037765: Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders.

DescriptionOpening the return material window takes too much.
After 5 minutes the popup is loaded.
Steps To ReproduceOpen the window on an environment with thousands of orders/orderlines.
Proposed SolutionChange the datable to use a hql query instead of a database view.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0037742 closeddmiguelez Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders. 

-  Notes
hgbot (developer)
2018-01-31 08:46

Repository: erp/backports/3.0PR17Q4.1
Changeset: 018323fa0ae3db264368f657b9f0f1ef8a09f34e
Author: David Miguelez <david.miguelez <at>>
Date: Mon Jan 29 11:38:22 2018 +0100
URL: [^]

Fixes Issue 37765. Fixes performance in Return Material Receipt P&E

In view m_rm_receipt_pick_edit a new column has been added with the
Business Partner from the Order.

This new column is used in the filter of the Return Material P&E Tab.
By doing so, additional cross joins with OrderLine and Order Tables
are avoided.
Also, the planner in Postgres is able to properly use the Business
Partner index.

M src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_TAB.xml
dmiguelez (developer)
2018-01-31 08:48

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2018-01-30 10:54 dmiguelez Type defect => backport
2018-01-30 10:54 dmiguelez Target Version => 3.0PR17Q4.1
2018-01-31 08:46 hgbot Checkin
2018-01-31 08:46 hgbot Note Added: 0102078
2018-01-31 08:46 hgbot Status scheduled => resolved
2018-01-31 08:46 hgbot Resolution open => fixed
2018-01-31 08:46 hgbot Fixed in SCM revision => [^]
2018-01-31 08:48 dmiguelez Review Assigned To => dmiguelez
2018-01-31 08:48 dmiguelez Note Added: 0102079
2018-01-31 08:48 dmiguelez Status resolved => closed
2018-01-31 08:48 dmiguelez Fixed in Version => 3.0PR18Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker