Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023571Openbravo ERPA. Platformpublic2013-04-17 12:132013-04-22 09:24
Reporteregoitz 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP23 
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
Summary0023571: Other index missing on m_storage_detail
DescriptionThe following index improves the performance of the Product Complete selector:

CREATE INDEX m_storage_detail_locator
  ON m_storage_detail
  USING btree
  (m_locator_id );


analyze m_storage_detail
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0023549 closed AugustoMauch Somo Missing indexes 
related to defect 0023902 closed shankarb A index missing affecting the m_inout_post process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-17 12:13egoitzNew Issue
2013-04-17 12:13egoitzAssigned To => AugustoMauch
2013-04-17 12:13egoitzModules => Core
2013-04-17 12:13egoitzOBNetwork customer => Yes
2013-04-17 12:13egoitzTriggers an Emergency Pack => No
2013-04-17 12:13egoitzRelationship addedrelated to 0023549
2013-04-17 12:50alostaleTag Attached: Performance
2013-04-17 15:09AugustoMauchIssue Monitored: shankarb
2013-04-17 15:10AugustoMauchReview Assigned To => shankarb
2013-04-17 15:10hgbotCheckin
2013-04-17 15:10hgbotNote Added: 0057995
2013-04-17 15:10hgbotStatusnew => resolved
2013-04-17 15:10hgbotResolutionopen => fixed
2013-04-17 15:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7b398b3fba7851e935c64ada4a4de6ca0601180e [^]
2013-04-19 12:52hudsonbotCheckin
2013-04-19 12:52hudsonbotNote Added: 0058044
2013-04-22 09:24shankarbNote Added: 0058079
2013-04-22 09:24shankarbStatusresolved => closed
2013-04-22 09:24shankarbFixed in Version => 3.0MP23
2013-05-23 13:32egoitzRelationship addedrelated to 0023902

Notes
(0057995)
hgbot   
2013-04-17 15:10   
Repository: erp/devel/pi
Changeset: 7b398b3fba7851e935c64ada4a4de6ca0601180e
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Apr 17 15:08:59 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7b398b3fba7851e935c64ada4a4de6ca0601180e [^]

Fixes issue 23571: Added missing index

And index has been added to the m_storage_detail table.

---
M src-db/database/model/tables/M_STORAGE_DETAIL.xml
---
(0058044)
hudsonbot   
2013-04-19 12:52   
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/872081925d42 [^]

Maturity status: Test
(0058079)
shankarb   
2013-04-22 09:24   
Code reviewed and tested in pi changeset 6f099465923b.