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-30 16:34
ReporteregoitzView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version3.0PR18Q1
StatusclosedFix in branchFixed in SCM revision7c5b6b9df580
ProjectionnoneETAnoneTarget Version3.0PR18Q1
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

0037764: 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-30 16:28

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

Fixes Issue 37764. 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-30 16:34

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.0PR18Q1
2018-01-30 16:28 hgbot Checkin
2018-01-30 16:28 hgbot Note Added: 0102061
2018-01-30 16:28 hgbot Status scheduled => resolved
2018-01-30 16:28 hgbot Resolution open => fixed
2018-01-30 16:28 hgbot Fixed in SCM revision => [^]
2018-01-30 16:34 dmiguelez Review Assigned To => dmiguelez
2018-01-30 16:34 dmiguelez Note Added: 0102064
2018-01-30 16:34 dmiguelez Status resolved => closed
2018-01-30 16:34 dmiguelez Fixed in Version => 3.0PR18Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker