Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037774Openbravo ERP07. Sales managementpublic2018-01-30 13:052018-02-07 13:52
Reporteregoitz 
Assigned ToTriage Omni OMS 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q4.1Fixed in Version3.0PR17Q4.1 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037774: Perfomance problems deleting an invoice on an environment with thousands of invoices and invoice lines
DescriptionIt takes few minutes to delete a order with only 3 lines.
Steps To Reproduce-Create a order
-Add 3 lines
-Delete the order
*It takes 3 minutes.
Proposed SolutionAddding the following index improves the deletion but it is not enought.

+ <index name="C_INVOICELINE_BOMPARENT" unique="false">
+ <index-column name="BOM_PARENT_ID"/>
+ <whereClause><![CDATA[BOM_PARENT_ID IS NOT NULL]]></whereClause>
+ </index>
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037772 closed dmiguelez Perfomance problems deleting an invoice on an environment with thousands of invoices and invoice lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-30 13:13dmiguelezTypedefect => backport
2018-01-30 13:13dmiguelezTarget Version => 3.0PR17Q4.1
2018-01-30 17:29dmiguelezTarget Version3.0PR17Q4.1 => 3.0PR17Q4.2
2018-02-07 13:07hgbotCheckin
2018-02-07 13:07hgbotNote Added: 0102247
2018-02-07 13:07hgbotStatusscheduled => resolved
2018-02-07 13:07hgbotResolutionopen => fixed
2018-02-07 13:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q4.1/rev/9b96ff21af72384d83c67aedee7bc03124b4c9a1 [^]
2018-02-07 13:51vmromanosTarget Version3.0PR17Q4.2 => 3.0PR17Q4.1
2018-02-07 13:52vmromanosReview Assigned To => vmromanos
2018-02-07 13:52vmromanosNote Added: 0102249
2018-02-07 13:52vmromanosStatusresolved => closed
2018-02-07 13:52vmromanosFixed in Version => 3.0PR17Q4.1

Notes
(0102247)
hgbot   
2018-02-07 13:07   
Repository: erp/backports/3.0PR17Q4.1
Changeset: 9b96ff21af72384d83c67aedee7bc03124b4c9a1
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Feb 07 13:05:20 2018 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q4.1/rev/9b96ff21af72384d83c67aedee7bc03124b4c9a1 [^]

Fixes Issue 37774. Adds several indexes that improve performance
in basic operations like deleting an Invoice or an Order

---
M src-db/database/model/tables/C_INVOICELINE.xml
M src-db/database/model/tables/C_ORDER.xml
M src-db/database/model/tables/M_COSTING.xml
M src-db/database/model/tables/M_INOUT.xml
M src-db/database/model/tables/M_MATCHPO.xml
---
(0102249)
vmromanos   
2018-02-07 13:52   
Code review OK