Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023902Openbravo ERPA. Platformpublic2013-05-23 13:322013-05-30 17:12
Reporteregoitz 
Assigned Toshankarb 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP24 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023902: A index missing affecting the m_inout_post process
DescriptionThe following index improves the m_inout_post process:

  
  CREATE INDEX m_storage_detail_uom
  ON m_storage_detail
  USING btree
  (c_uom_id);
Steps To ReproduceExecute the process without the index and with the index and compare the time to finish the process
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0023571 closed AugustoMauch Other index missing on m_storage_detail 
related to defect 0023549 closed AugustoMauch Somo Missing indexes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-23 13:32egoitzNew Issue
2013-05-23 13:32egoitzAssigned To => AugustoMauch
2013-05-23 13:32egoitzModules => Core
2013-05-23 13:32egoitzTriggers an Emergency Pack => No
2013-05-23 13:32egoitzRelationship addedrelated to 0023571
2013-05-23 13:32egoitzRelationship addedrelated to 0023549
2013-05-23 13:32egoitzTag Attached: Performance
2013-05-28 07:34shankarbAssigned ToAugustoMauch => shankarb
2013-05-28 07:36shankarbReview Assigned To => AugustoMauch
2013-05-28 07:36shankarbIssue Monitored: AugustoMauch
2013-05-28 07:42hgbotCheckin
2013-05-28 07:42hgbotNote Added: 0058979
2013-05-28 07:42hgbotStatusnew => resolved
2013-05-28 07:42hgbotResolutionopen => fixed
2013-05-28 07:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ded79d8fb1d06d14245528bba40eb2df6572d338 [^]
2013-05-28 23:56hudsonbotCheckin
2013-05-28 23:56hudsonbotNote Added: 0059011
2013-05-30 17:12AugustoMauchNote Added: 0059077
2013-05-30 17:12AugustoMauchStatusresolved => closed
2013-05-30 17:12AugustoMauchFixed in Version => 3.0MP24

Notes
(0058979)
hgbot   
2013-05-28 07:42   
Repository: erp/devel/pi
Changeset: ded79d8fb1d06d14245528bba40eb2df6572d338
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Tue May 28 11:11:50 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ded79d8fb1d06d14245528bba40eb2df6572d338 [^]

Fixes Issue 23902: A index missing affecting the m_inout_post process

An index has been added on m_storage_detail.

---
M src-db/database/model/tables/M_STORAGE_DETAIL.xml
---
(0059011)
hudsonbot   
2013-05-28 23:56   
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/4ecad5b5150f [^]

Maturity status: Test
(0059077)
AugustoMauch   
2013-05-30 17:12   
Code reviewed and verified in pi@1693de72b307