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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0032235
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Modules] Analyticsmajoralways2016-02-15 16:482016-04-11 15:29
ReporterngarciaView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0032235: Update Analytics Fact Tables background process takes too long when the tables are empty

DescriptionUpdate Analytics Fact Tables background process takes too long when the tables are empty: the first launch or a launch after launching the Clear Fact Tables process
Steps To ReproduceIn a copy of the customer environment the process has lasted three days. The records created were:

obanaly_fact_discounts - 338464
obanaly_fact_order - 2795442
obanaly_fact_salesordheader - 1136997
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0032500 closedplatform Openbravo ERP incorrect duration in process monitor for times bigger than 1 day 
related to design defect 0032192 acknowledgedplatform Modules First launch of Update Time Dimension Refs + Tree Closure Table background process takes too long 
related to feature request 0033148 closedplatform Modules Configurable Update Analytics Fact Tables Process 

-  Notes
(0085204)
hgbot (developer)
2016-03-17 14:42

Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 1a8b9d040d962649cf227e69aee97d0df7a9bac3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:50:49 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/1a8b9d040d962649cf227e69aee97d0df7a9bac3 [^]

related to bug 32235: added extra logging info

---
M src/org/openbravo/client/analytics/OBOlapClosureTreeHandler.java
M src/org/openbravo/client/analytics/TimeDimensionProvider.java
---
(0085205)
hgbot (developer)
2016-03-17 14:42

Repository: erp/pmods/org.openbravo.client.analytics
Changeset: fd3590548ef5ef565be93bcf1fcb871dd6f218db
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:52:09 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/fd3590548ef5ef565be93bcf1fcb871dd6f218db [^]

related to bug 32235: do a single query to calculate taxes

---
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
---
(0085206)
hgbot (developer)
2016-03-17 14:42

Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 4d9d78b83b3d5b2d0c2c6c9a17e71cab1ab28c3c
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:53:21 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/4d9d78b83b3d5b2d0c2c6c9a17e71cab1ab28c3c [^]

related to bug 32235: improved bp birthdate calcualtion

  using queries instead of loading children lists

---
M src/org/openbravo/client/analytics/OBAnalyticsFactOrderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsUtils.java
---
(0085207)
hgbot (developer)
2016-03-17 14:43

Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 6905e0d070be9f69213016e9f914256ad6492112
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 17 14:29:35 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6905e0d070be9f69213016e9f914256ad6492112 [^]

related to bug 32235: eager initialization in getData queries

  Elements that belong to mapped properties are now eagerly initialized, this
  improves performance (in around 40% of time savings) by preventing db roundtrips
  DAL objects are initialized from a single query now.

---
M src/org/openbravo/client/analytics/OBAnalyticsFactOrderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
---
(0085208)
alostale (developer)
2016-03-17 14:48

Published version 1.2.600 improves perfomance for this process making it around 40% faster. With provided dataset, it was reduced from 3 days to 41 hours.

- Issue History
Date Modified Username Field Change
2016-02-15 16:48 ngarcia New Issue
2016-02-15 16:48 ngarcia Assigned To => platform
2016-02-15 16:48 ngarcia Relationship added related to 0032192
2016-03-17 14:17 alostale Relationship added related to 0032500
2016-03-17 14:38 alostale Assigned To platform => alostale
2016-03-17 14:38 alostale Status new => acknowledged
2016-03-17 14:42 hgbot Checkin
2016-03-17 14:42 hgbot Note Added: 0085204
2016-03-17 14:42 hgbot Checkin
2016-03-17 14:42 hgbot Note Added: 0085205
2016-03-17 14:42 hgbot Checkin
2016-03-17 14:42 hgbot Note Added: 0085206
2016-03-17 14:43 hgbot Checkin
2016-03-17 14:43 hgbot Note Added: 0085207
2016-03-17 14:48 alostale Note Added: 0085208
2016-04-11 15:29 alostale Type defect => design defect
2016-06-06 11:21 caristu Relationship added related to 0033148


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker