0025065: Big combos on sales order and sales invoice windows

Description

There are some tabledir columns causing performance problems on c_orderline and c_invoiceline tables. The column is m_offer_id on both tables.

Steps To Reproduce

On an environment with a lot of rows on M_offer table check the log:

Warning: In the window Sales Invoice, in tab Lines the combo fields inpmOfferId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.

Warning: In the window Sales Order, in tab Lines the combo fields inpmOfferId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0062046) hgbot (developer) 2013-11-07 09:00	Repository: erp/devel/pi Changeset: 792f4a583b0ff0b1307ea01b52c41d8be1c78455 Author: Carlos Aristu <carlos.aristu <at> openbravo.com> Date: Wed Nov 06 14:01:19 2013 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/792f4a583b0ff0b1307ea01b52c41d8be1c78455 [^] fixes issue 25065: Big combos on sales order and sales invoice windows --- M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_REFERENCE.xml M src-db/database/sourcedata/OBUISEL_SELECTOR.xml ---

(0062134) egoitz (developer) 2013-11-15 09:09	verified

(0062241) hudsonbot (developer) 2013-11-19 19:07	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/ab71e0273dc1 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2013-10-31 18:31	egoitz	New Issue
2013-10-31 18:31	egoitz	Assigned To	=> caristu
2013-10-31 18:31	egoitz	Modules	=> Core
2013-10-31 18:31	egoitz	Triggers an Emergency Pack	=> No
2013-11-07 09:00	hgbot	Checkin
2013-11-07 09:00	hgbot	Note Added: 0062046
2013-11-07 09:00	hgbot	Status	new => resolved
2013-11-07 09:00	hgbot	Resolution	open => fixed
2013-11-07 09:00	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/792f4a583b0ff0b1307ea01b52c41d8be1c78455 [^]
2013-11-15 09:09	egoitz	Review Assigned To	=> egoitz
2013-11-15 09:09	egoitz	Note Added: 0062134
2013-11-15 09:09	egoitz	Status	resolved => closed
2013-11-15 09:09	egoitz	Fixed in Version	=> 3.0MP30
2013-11-19 19:07	hudsonbot	Checkin
2013-11-19 19:07	hudsonbot	Note Added: 0062241