Virtual Column M_Product.CostStandard too heavy

Description

The script 360lts-i1.0a/postgresql/862a_ManufacturingLight.sql added a virtual column to M_Product for CostStandard with the following query:

It is not recommended to add such virtual columns to big and heavily used tables, in a migrated adempiere installation the products for one of the tenants is 9766 rows, and M_Cost has 31.529 - but the Product window is not able to load the records in the 30 seconds timeout.

Disabling that column makes the opening immediate.

I think is better to disable that column and if somebody wants it better to implement it in a subtab - or in a Help Widget.

Environment

None

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Priority

Major
Configure