Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023891Openbravo ERPA. Platformpublic2013-05-23 01:102013-07-24 21:31
Reporteregoitz 
Assigned ToAugustoMauch 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP26 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023891: Create Inventory Count List process in Physical inventory window takes too long with large amount of data
DescriptionThe Create Inventory Count List process in Physical inventory window takes too long with large amount of data.
Steps To Reproduce-ON a database with arrond 1.300.000 products execute the process create inventory count list.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0024447 closed AugustoMauch Add a index on the m_transaction table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-23 01:10egoitzNew Issue
2013-05-23 01:10egoitzAssigned To => dmiguelez
2013-05-23 01:10egoitzModules => Core
2013-05-23 01:10egoitzOBNetwork customer => Yes
2013-05-23 01:10egoitzTriggers an Emergency Pack => No
2013-05-23 09:37dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-07-22 13:11egoitzNote Added: 0060146
2013-07-22 13:12egoitzAssigned Tojonalegriaesarte => AugustoMauch
2013-07-22 13:12egoitzCategory04. Warehouse management => A. Platform
2013-07-22 13:12egoitzDescription Updatedbug_revision_view_page.php?rev_id=4905#r4905
2013-07-22 13:12egoitzTag Attached: Performance
2013-07-24 10:50AugustoMauchIssue Monitored: shankarb
2013-07-24 10:51AugustoMauchReview Assigned To => shankarb
2013-07-24 10:51hgbotCheckin
2013-07-24 10:51hgbotNote Added: 0060224
2013-07-24 10:51hgbotStatusnew => resolved
2013-07-24 10:51hgbotResolutionopen => fixed
2013-07-24 10:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d3f8f2ef8823bf4cafa82af318102dbf4e3d6a4c [^]
2013-07-24 15:23shankarbNote Added: 0060262
2013-07-24 15:23shankarbStatusresolved => closed
2013-07-24 15:23shankarbFixed in Version => 3.0MP26
2013-07-24 21:31hudsonbotCheckin
2013-07-24 21:31hudsonbotNote Added: 0060294
2013-07-31 00:14egoitzRelationship addedrelated to 0024447

Notes
(0060146)
egoitz   
2013-07-22 13:11   
The following indexes has improved the performance from some hours to 15 minuts.

One index on the m_storage_detail_id column on the m_stock_proposed table.

Also one index for each of the following columns on the m_transaction table:

m_movementline_id
m_inventoryline_id
m_inoutline_id
(0060224)
hgbot   
2013-07-24 10:51   
Repository: erp/devel/pi
Changeset: d3f8f2ef8823bf4cafa82af318102dbf4e3d6a4c
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Jul 24 10:50:12 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d3f8f2ef8823bf4cafa82af318102dbf4e3d6a4c [^]

Fixes issue 23891: Four indexes have been added to improve process perforance

These indexes have been added to improve the performance of the Create Inventory Count List process in the Physical Inventory window:
- m_stock_proposed table -> m_storage_detail_id
- m_transaction table -> m_movementline_id, m_inventoryline_id, m_inoutline_id

---
M src-db/database/model/tables/M_STOCK_PROPOSED.xml
M src-db/database/model/tables/M_TRANSACTION.xml
---
(0060262)
shankarb   
2013-07-24 15:23   
Code reviewed and tested in pi changeset 509129b9fd7a
(0060294)
hudsonbot   
2013-07-24 21:31   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/965b32a20794 [^]

Maturity status: Test