0026202: Big combos causing performance problems.

Description

Warning: In the window Sales Order, in tab Lines the combo fields inpcOrderDiscountId 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 Production Run, in tab Production Run the combo fields inpmaWrphaseId 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 Product, in tab Product the combo fields inpmaProcessplanId 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 Process Plan, in tab Operation the combo fields inpmaProcessplanVersionId 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 Process Plan, in tab I/O Products the combo fields inpmaSequenceId 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 Product, in tab Factory References the combo fields inpmProductId2 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.

bc4ec62b 2014-04-08 11:07:09,868 [TP-Processor72] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Production Run, in tab Defects the combo fields inpmProductionlineId 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.
bc4ec62b 2014-04-08 11:07:30,324 [TP-Processor30] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Sales Invoice, in tab Reversed Invoices the combo fields inpcInvoiceId 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.
bc4ec62b 2014-04-08 11:07:30,888 [TP-Processor78] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Sales Invoice, in tab Reversed Invoices the combo fields inpcInvoiceId 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.

bc4ec62b 2014-04-08 11:09:04,952 [TP-Processor61] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Labels, in tab Labels the combo fields inpmInventorylineId,inpmProductionlineId,inpmInoutlineId 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.

61788dfd 2014-04-08 04:59:51,445 [TP-Processor11] WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Financial Account, in tab Transaction the combo fields inpfinReconciliationId 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.

Steps To Reproduce

Use the application with a big amount of data on tables such us ma_sequence,
m_product_id, ma_process_plan_version, ma_wrpahse, c_order_discount

Proposed Solution

Change the references to new selectors

Issue History
Date Modified	Username	Field	Change
2014-04-08 09:57	egoitz	New Issue
2014-04-08 09:57	egoitz	Assigned To	=> AugustoMauch
2014-04-08 09:57	egoitz	Modules	=> Core
2014-04-08 09:57	egoitz	Triggers an Emergency Pack	=> No
2014-04-08 09:58	egoitz	Tag Attached: Performance
2014-04-08 09:58	egoitz	Issue Monitored: networkb
2014-04-08 12:14	egoitz	Description Updated	View Revisions
2014-04-08 12:43	egoitz	Resolution time	=> 1398722400
2014-04-08 12:43	egoitz	Priority	normal => urgent
2014-04-08 13:00	egoitz	Description Updated	View Revisions
2014-04-08 13:20	egoitz	Target Version	=> PR14Q3
2014-04-24 09:10	alostale	Relationship added	related to 0026267
2014-05-05 13:01	jonalegriaesarte	Note Added: 0066811
2014-05-05 13:01	jonalegriaesarte	Status	new => closed
2014-05-05 13:01	jonalegriaesarte	Resolution	open => no change required

Notes
(0066811) jonalegriaesarte (reporter) 2014-05-05 13:01	This bug is part of the re-implementation of the selectors that will be included in Q3 release