0023276: We should create an index between tables C_orderline and c_orderlinetax

Description

We 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

Tags

Relationships [ Relation Graph ] [ Dependency Graph ]

has duplicate

defect

3.0MP22

closed

Inserting order lines takes long when there is a big amount of data on c_orderline table

Notes
(0057183) hgbot (developer) 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 (developer) 2013-03-11 16:53	Verified

Issue History
Date Modified	Username	Field	Change
2013-03-11 13:41	jecharri	New Issue
2013-03-11 13:41	jecharri	Assigned To	=> AugustoMauch
2013-03-11 13:41	jecharri	Web browser	=> Google Chrome
2013-03-11 13:41	jecharri	Modules	=> Core
2013-03-11 13:41	jecharri	Triggers an Emergency Pack	=> No
2013-03-11 16:48	hgbot	Checkin
2013-03-11 16:48	hgbot	Note Added: 0057183
2013-03-11 16:48	hgbot	Status	new => resolved
2013-03-11 16:48	hgbot	Resolution	open => fixed
2013-03-11 16:48	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/85338ed3557ca20d66fdc838c1704dc969701725 [^]
2013-03-11 16:48	egoitz	Tag Attached: Performance
2013-03-11 16:49	egoitz	Relationship added	has duplicate 0023278
2013-03-11 16:53	jecharri	Review Assigned To	=> jecharri
2013-03-11 16:53	jecharri	Note Added: 0057184
2013-03-11 16:53	jecharri	Status	resolved => closed