Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023276Openbravo ERPA. Platformpublic2013-03-11 13:412013-03-11 16:53
Reporterjecharri 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned Tojecharri
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023276: We should create an index between tables C_orderline and c_orderlinetax
DescriptionWe should create an index between tables C_orderline and c_orderlinetax by column c_ordeline_id

This problem is creating a performance problems.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
has duplicate defect 00232783.0MP22 closed dmiguelez Inserting order lines takes long when there is a big amount of data on c_orderline table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-11 13:41jecharriNew Issue
2013-03-11 13:41jecharriAssigned To => AugustoMauch
2013-03-11 13:41jecharriWeb browser => Google Chrome
2013-03-11 13:41jecharriModules => Core
2013-03-11 13:41jecharriOBNetwork customer => No
2013-03-11 13:41jecharriTriggers an Emergency Pack => No
2013-03-11 16:48hgbotCheckin
2013-03-11 16:48hgbotNote Added: 0057183
2013-03-11 16:48hgbotStatusnew => resolved
2013-03-11 16:48hgbotResolutionopen => fixed
2013-03-11 16:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/85338ed3557ca20d66fdc838c1704dc969701725 [^]
2013-03-11 16:48egoitzTag Attached: Performance
2013-03-11 16:49egoitzRelationship addedhas duplicate 0023278
2013-03-11 16:53jecharriReview Assigned To => jecharri
2013-03-11 16:53jecharriNote Added: 0057184
2013-03-11 16:53jecharriStatusresolved => closed

Notes
(0057183)
hgbot   
2013-03-11 16:48   
Repository: erp/devel/pi
Changeset: 85338ed3557ca20d66fdc838c1704dc969701725
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Mon Mar 11 16:47:42 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/85338ed3557ca20d66fdc838c1704dc969701725 [^]

Fixed Issue 0023276: Index on c_orderlinetax table

---
M src-db/database/model/tables/C_ORDERLINETAX.xml
---
(0057184)
jecharri   
2013-03-11 16:53   
Verified