Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0037764Openbravo ERP03. Procurement managementpublic2018-01-29 09:412018-01-30 16:34
egoitz 
dmiguelez 
urgentmajoralways
closedfixed 
5
 
3.0PR18Q13.0PR18Q1 
dmiguelez
Core
No
0037764: Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders.
Opening the return material window takes too much.
After 5 minutes the popup is loaded.
Open the window on an environment with thousands of orders/orderlines.
Change the datable to use a hql query instead of a database view.
No tags attached.
blocks defect 0037742 closed dmiguelez Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders. 
Issue History
2018-01-30 10:54dmiguelezTypedefect => backport
2018-01-30 10:54dmiguelezTarget Version => 3.0PR18Q1
2018-01-30 16:28hgbotCheckin
2018-01-30 16:28hgbotNote Added: 0102061
2018-01-30 16:28hgbotStatusscheduled => resolved
2018-01-30 16:28hgbotResolutionopen => fixed
2018-01-30 16:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR18Q1/rev/7c5b6b9df580574560ce1257d0ead9eab2d64601 [^]
2018-01-30 16:34dmiguelezReview Assigned To => dmiguelez
2018-01-30 16:34dmiguelezNote Added: 0102064
2018-01-30 16:34dmiguelezStatusresolved => closed
2018-01-30 16:34dmiguelezFixed in Version => 3.0PR18Q1

Notes
(0102061)
hgbot   
2018-01-30 16:28   
Repository: erp/backports/3.0PR18Q1
Changeset: 7c5b6b9df580574560ce1257d0ead9eab2d64601
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 29 11:38:22 2018 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR18Q1/rev/7c5b6b9df580574560ce1257d0ead9eab2d64601 [^]

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
---
(0102064)
dmiguelez   
2018-01-30 16:34   
Code Review + Testing Ok