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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031874
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Modules] Valued Stock Enhancedmajoralways2016-01-13 16:592016-12-28 10:54
ReporterdmiguelezView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Regression introduced in release
Summary

0031874: Performance problems in Valued Stock Report Enhanced

DescriptionPerformance problems in Valued Stock Report Enhanced with large volumes of data.
Steps To ReproducePerformance problems in Valued Stock Report Enhanced with large volumes of data.
Proposed SolutionCreate an aggregated table to store the information per accounting Period to the time it takes to run calculations needed in order to show the report.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of feature request 0034482 closedTriage Omni OMS Openbravo ERP Improve performance in Enhanced Valued Stock Report 
related to defect 0030197 closedpsarobe Modules Enhanced valued stock report's performance is bad when no warehouse is filtered. 
related to design defect 0032493 closedvmromanos Openbravo ERP Pareto Product Report takes too long in an environment with big amount of data 
causes defect 0035415 closeddmiguelez Openbravo ERP Generate Aggregated Data Background doesn't work in Oracle 

-  Notes
(0083256)
dmiguelez (developer)
2016-01-13 17:04

 The proposal is:

1. Create an aggregated Table to store aggregated information for Stock and Valuation of the Stock.
  - This information should be grouped for each Product and Locator
  - This information needs to be created for each closed Accounting Period. The reason to do it is because the Valued Stock Report can be run as of Date, so it is needed to have aggregated information for different dates.
  - The information will be only stored for Closed and Permanently Closed Periods.

2. Create a Process to insert the information into the Table for each Closed Period. This Process will be scheduled as a background Process.

3. When a Period is Closed or Permanently Closed, the background Process will take it into account and will create the needed data when the process is run.

4. When a Period is Opened, if there is data for that Period (or for the next ones), it will be automatically deleted at that moment.

- Issue History
Date Modified Username Field Change
2016-01-13 16:59 dmiguelez New Issue
2016-01-13 16:59 dmiguelez Assigned To => Triage Finance
2016-01-13 16:59 dmiguelez Relationship added related to 0030197
2016-01-13 17:04 dmiguelez Note Added: 0083256
2016-04-19 14:45 aferraz Relationship added related to 0032493
2016-04-22 14:41 ngarcia Issue Monitored: ngarcia
2016-12-28 10:54 aferraz Review Assigned To => aferraz
2016-12-28 10:54 aferraz Relationship added duplicate of 0034482
2016-12-28 10:54 aferraz Status new => closed
2016-12-28 10:54 aferraz Resolution open => duplicate
2017-03-02 17:40 vmromanos Relationship added causes 0035415

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker