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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039329
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Analyticsmajoralways2018-09-20 12:442018-10-08 13:33
ReporterJONHMView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc61366f60aa4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0039329: Deleting an order on an environment with analytics installed is slower

DescriptionDeleting an order on an environment with analytics installed is slower because of the referential integrity.
Steps To ReproduceOn environment with lots of data and analytics installed:
- Delete an order (delete from C_Order where C_Order_ID=$1)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0039328 closedAtulOpenbravo Modules Analytics should not have referential integrity with transactional data 
related to defect 0039447 closedmarkmm82 Openbravo ERP slow delete action in some backend windows 

-  Notes
(0107210)
dmiguelez (developer)
2018-10-08 13:01

 Tested in a Client's environment with this result.

Before the change, when deleting an Order header, in the explain plan:
Trigger for constraint obanaly_fact_disc_order_fk: time=109.325 calls=1
Trigger for constraint obanaly_fact_order_order_fk: time=4049.113 calls=1
Trigger for constraint obanaly_fact_soh_order_fk: time=14033.799 calls=1

After the change:
Trigger for constraint obanaly_fact_disc_order_fk: time=19.878 calls=1
Trigger for constraint obanaly_fact_order_order_fk: time=32.450 calls=1
Trigger for constraint obanaly_fact_soh_order_fk: time=39.993 calls=1
(0107212)
hgbot (developer)
2018-10-08 13:08

 Repository: erp/pmods/org.openbravo.client.analytics
Changeset: c61366f60aa41f2ef59139dab124a6a1b21180ee
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Oct 08 12:58:49 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/c61366f60aa41f2ef59139dab124a6a1b21180ee [^]

Fixes Issue 39329. Adds missing indexes in aggregated tables for
c_order_id column

---
M src-db/database/model/tables/OBANALY_FACT_ORDER.xml
M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml
---
(0107217)
Sandrahuguet (developer)
2018-10-08 13:33

 Code review + testing OK

- Issue History
Date Modified Username Field Change
2018-09-20 12:44 JONHM New Issue
2018-09-20 12:44 JONHM Assigned To => platform
2018-09-20 12:44 JONHM Resolution time => 1539208800
2018-09-20 12:58 JONHM Relationship added related to 0039328
2018-09-21 07:43 alostale Assigned To platform => Triage Finance
2018-10-08 13:01 dmiguelez Note Added: 0107210
2018-10-08 13:08 hgbot Checkin
2018-10-08 13:08 hgbot Note Added: 0107212
2018-10-08 13:08 hgbot Status new => resolved
2018-10-08 13:08 hgbot Resolution open => fixed
2018-10-08 13:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/c61366f60aa41f2ef59139dab124a6a1b21180ee [^]
2018-10-08 13:32 Sandrahuguet Assigned To Triage Finance => dmiguelez
2018-10-08 13:33 Sandrahuguet Review Assigned To => Sandrahuguet
2018-10-08 13:33 Sandrahuguet Note Added: 0107217
2018-10-08 13:33 Sandrahuguet Status resolved => closed
2018-10-15 14:13 alostale Relationship added related to 0039447

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker