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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023902
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2013-05-23 13:322013-05-30 17:12
ReporteregoitzView Statuspublic 
Assigned Toshankarb 
PriorityimmediateResolutionfixedFixed in Version3.0MP24
StatusclosedFix in branchFixed in SCM revisionded79d8fb1d0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023902: 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
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0023571 closedAugustoMauch Other index missing on m_storage_detail 
related to defect 0023549 closedAugustoMauch Somo Missing indexes 

-  Notes
(0058979)
hgbot (developer)
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 (developer)
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 (manager)
2013-05-30 17:12

Code reviewed and verified in pi@1693de72b307

- Issue History
Date Modified Username Field Change
2013-05-23 13:32 egoitz New Issue
2013-05-23 13:32 egoitz Assigned To => AugustoMauch
2013-05-23 13:32 egoitz Modules => Core
2013-05-23 13:32 egoitz Triggers an Emergency Pack => No
2013-05-23 13:32 egoitz Relationship added related to 0023571
2013-05-23 13:32 egoitz Relationship added related to 0023549
2013-05-23 13:32 egoitz Tag Attached: Performance
2013-05-28 07:34 shankarb Assigned To AugustoMauch => shankarb
2013-05-28 07:36 shankarb Review Assigned To => AugustoMauch
2013-05-28 07:36 shankarb Issue Monitored: AugustoMauch
2013-05-28 07:42 hgbot Checkin
2013-05-28 07:42 hgbot Note Added: 0058979
2013-05-28 07:42 hgbot Status new => resolved
2013-05-28 07:42 hgbot Resolution open => fixed
2013-05-28 07:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ded79d8fb1d06d14245528bba40eb2df6572d338 [^]
2013-05-28 23:56 hudsonbot Checkin
2013-05-28 23:56 hudsonbot Note Added: 0059011
2013-05-30 17:12 AugustoMauch Note Added: 0059077
2013-05-30 17:12 AugustoMauch Status resolved => closed
2013-05-30 17:12 AugustoMauch Fixed in Version => 3.0MP24


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker