Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023278Openbravo ERP07. Sales managementpublic2013-03-11 13:472013-03-11 16:49
Reporteregoitz 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version 
Target Version3.0MP22Fixed in Version3.0MP22 
Merge Request Status
Review Assigned Tojecharri
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023278: Inserting order lines takes long when there is a big amount of data on c_orderline table
DescriptionInserting order lines takes long when there is a big amount of data on c_orderline table
Steps To Reproduce-On a table with a lot of rows on the c_orderline table insert a new line.
*It takes few seconds when should be immediate
Proposed SolutionCREATE INDEX c_orderlinetax_orderline ON c_orderlinetax USING
btree (c_orderline_id);
Additional Information
TagsPerformance
Relationships
duplicate of defect 0023276pi closed AugustoMauch We should create an index between tables C_orderline and c_orderlinetax 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-11 13:47egoitzNew Issue
2013-03-11 13:47egoitzAssigned To => dmiguelez
2013-03-11 13:47egoitzModules => Core
2013-03-11 13:47egoitzTriggers an Emergency Pack => No
2013-03-11 13:47egoitzTag Attached: Performance
2013-03-11 16:49egoitzReview Assigned To => jecharri
2013-03-11 16:49egoitzRelationship addedduplicate of 0023276
2013-03-11 16:49egoitzStatusnew => closed
2013-03-11 16:49egoitzResolutionopen => duplicate
2013-03-11 16:49egoitzFixed in Version => 3.0MP22

There are no notes attached to this issue.