Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037774
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajorhave not tried2018-01-30 13:052018-02-07 13:52
ReporteregoitzView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q4.1
StatusclosedFix in branchFixed in SCM revision9b96ff21af72
ProjectionnoneETAnoneTarget Version3.0PR17Q4.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037774: 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>
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0037772 closeddmiguelez Perfomance problems deleting an invoice on an environment with thousands of invoices and invoice lines 

-  Notes
(0102247)
hgbot (developer)
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 (developer)
2018-02-07 13:52

Code review OK

- Issue History
Date Modified Username Field Change
2018-01-30 13:13 dmiguelez Type defect => backport
2018-01-30 13:13 dmiguelez Target Version => 3.0PR17Q4.1
2018-01-30 17:29 dmiguelez Target Version 3.0PR17Q4.1 => 3.0PR17Q4.2
2018-02-07 13:07 hgbot Checkin
2018-02-07 13:07 hgbot Note Added: 0102247
2018-02-07 13:07 hgbot Status scheduled => resolved
2018-02-07 13:07 hgbot Resolution open => fixed
2018-02-07 13:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q4.1/rev/9b96ff21af72384d83c67aedee7bc03124b4c9a1 [^]
2018-02-07 13:51 vmromanos Target Version 3.0PR17Q4.2 => 3.0PR17Q4.1
2018-02-07 13:52 vmromanos Review Assigned To => vmromanos
2018-02-07 13:52 vmromanos Note Added: 0102249
2018-02-07 13:52 vmromanos Status resolved => closed
2018-02-07 13:52 vmromanos Fixed in Version => 3.0PR17Q4.1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker