Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037885Openbravo ERP02. Master data managementpublic2018-02-12 12:262018-03-02 21:18
ReporterJONHM 
Assigned Tomarkmm82 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037885: Performance issue in Physical Inventory when deleting a record with too many lines
DescriptionPerformance issue in Physical Inventory when deleting a record with too many lines. Tested on an environment which have a physical inventory with 23K lines.
Steps To ReproduceOpen physical inventory window
Delete a record with 23K lines
- It takes for about 60 minutes
Proposed SolutionCreate an index on m_inventoryline table:

CREATE INDEX m_inventoryline_inventoryline
  ON m_inventoryline (relatedinventorylineid)
  WHERE relatedinventorylineid IS NOT NULL;

- It reduces the time up to 1 minute
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-12 12:26JONHMNew Issue
2018-02-12 12:26JONHMAssigned To => Triage Finance
2018-02-12 12:26JONHMModules => Core
2018-02-12 12:26JONHMResolution time => 1520204400
2018-02-12 12:26JONHMTriggers an Emergency Pack => No
2018-02-14 15:22markmm82Assigned ToTriage Finance => markmm82
2018-02-14 15:26markmm82Statusnew => scheduled
2018-02-22 16:10hgbotCheckin
2018-02-22 16:10hgbotNote Added: 0102601
2018-02-22 16:10hgbotStatusscheduled => resolved
2018-02-22 16:10hgbotResolutionopen => fixed
2018-02-22 16:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72f923b76be55ff620debeb56bbf76a5bef1422f [^]
2018-02-22 16:11dmiguelezReview Assigned To => dmiguelez
2018-02-22 16:11dmiguelezNote Added: 0102602
2018-02-22 16:11dmiguelezStatusresolved => closed
2018-02-22 16:11dmiguelezFixed in Version => 3.0PR18Q2
2018-03-02 21:18hudsonbotCheckin
2018-03-02 21:18hudsonbotNote Added: 0102946

Notes
(0102601)
hgbot   
2018-02-22 16:10   
Repository: erp/devel/pi
Changeset: 72f923b76be55ff620debeb56bbf76a5bef1422f
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Feb 16 13:08:17 2018 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/72f923b76be55ff620debeb56bbf76a5bef1422f [^]

Fixes issue 37885:Performance issue in Physical Inventory when deleting a record
with too many lines

To improve the performance when deleting inventory records with too many lines was
added a new index on RELATEDINVENTORYLINEID column of M_INVENTORYLINE_INVENTORYLINE
table for those not null

---
M src-db/database/model/tables/M_INVENTORYLINE.xml
---
(0102602)
dmiguelez   
2018-02-22 16:11   
Code Review + Testing Ok
(0102946)
hudsonbot   
2018-03-02 21:18   
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/05dece3dc80b [^]
Maturity status: Test