Skip to content

Fixes ISSUE-52072: Updates reference of c_order.Cancelledorder_id from table...

Augusto Mauch requested to merge openbravo/devel/openbravo:fix/52072-cancelledorder-selector into master

Fixes ISSUE-52072: Updates reference of c_order.Cancelledorder_id from table to selector to improve performance

The use of the previous reference was resulting in very slow queries that could take hours to complete, such us:

SELECT td0.C_Order_ID AS ID, ... FROM C_Order td0 WHERE ... AND (td0.isActive = Y OR td0.C_Order_ID = ($1) )

The new reference used does not generate those potentially slow queries

Try-run: https://builds.openbravo.com/job/try-init/2314/console

Edited by Augusto Mauch

Merge request reports