Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024447Openbravo ERPA. Platformpublic2013-07-31 00:142013-07-31 20:56
Reporteregoitz 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityhave 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
Summary0024447: Add a index on the m_transaction table
DescriptionAdd a index on column M_PRODUCTIONLINE_ID on m_transaction table
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0023891 closed AugustoMauch Create Inventory Count List process in Physical inventory window takes too long with large amount of data 
related to design defect 0020421 closed alostale Review needed indexes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-07-31 00:14egoitzNew Issue
2013-07-31 00:14egoitzAssigned To => AugustoMauch
2013-07-31 00:14egoitzModules => Core
2013-07-31 00:14egoitzOBNetwork customer => Yes
2013-07-31 00:14egoitzTriggers an Emergency Pack => No
2013-07-31 00:14egoitzRelationship addedrelated to 0023891
2013-07-31 10:08AugustoMauchTag Attached: Performance
2013-07-31 10:09AugustoMauchRelationship addedrelated to 0020421
2013-07-31 10:34AugustoMauchIssue Monitored: shankarb
2013-07-31 10:34AugustoMauchReview Assigned To => shankarb
2013-07-31 10:34hgbotCheckin
2013-07-31 10:34hgbotNote Added: 0060393
2013-07-31 10:34hgbotStatusnew => resolved
2013-07-31 10:34hgbotResolutionopen => fixed
2013-07-31 10:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/70d6ec4a68264a7b523edae50ef3886e42253f1b [^]
2013-07-31 12:20shankarbNote Added: 0060401
2013-07-31 12:20shankarbStatusresolved => closed
2013-07-31 12:20shankarbFixed in Version => 3.0MP26
2013-07-31 20:56hudsonbotCheckin
2013-07-31 20:56hudsonbotNote Added: 0060442

Notes
(0060393)
hgbot   
2013-07-31 10:34   
Repository: erp/devel/pi
Changeset: 70d6ec4a68264a7b523edae50ef3886e42253f1b
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Jul 31 10:33:35 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/70d6ec4a68264a7b523edae50ef3886e42253f1b [^]

Fixes issue 24447: Adds index on m_transaction.m_productionline_id

---
M src-db/database/model/tables/M_TRANSACTION.xml
---
(0060401)
shankarb   
2013-07-31 12:20   
Code reviewed and tested in pi changeset 7e5e4ef85dc7.
(0060442)
hudsonbot   
2013-07-31 20: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/4dbc2065ad03 [^]

Maturity status: Test