0030529: Potential full c_orderline scan in M_Reservation_trg

Description

Trigger on M_Reservation table does a count on all order lines without any filtering.

If this code is executed in an environment with a decent amount of orders, it can take ages to complete.

Steps To Reproduce

I have not reproduced it, but just read the code in M_RESERVATION_TRG.xml :

https://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583#l1.28 [^]

select count (*) into v_count from c_orderline;

it looks like some missing debug code forgotten to remove as it is never used

Tags

Approved

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0030516

closed

AtulOpenbravo

Potential full c_orderline scan in M_Reservation_trg

Notes
(0079270) hgbot (developer) 2015-08-10 09:12	Repository: erp/backports/3.0PR15Q2.4 Changeset: 14a82c0a34bd2974fe1836847ea6ec5fd2fd3a0f Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Mon Aug 10 10:22:48 2015 +0530 URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.4/rev/14a82c0a34bd2974fe1836847ea6ec5fd2fd3a0f [^] Fixes Issue 30529:Potential full c_orderline scan in M_Reservation_trg Removed unwanted line in code which fully scans c_orderline. --- M src-db/database/model/triggers/M_RESERVATION_TRG.xml ---

Issue History
Date Modified	Username	Field	Change
2015-08-10 06:51	AtulOpenbravo	Type	defect => backport
2015-08-10 06:51	AtulOpenbravo	Target Version	=> 3.0PR15Q2.4
2015-08-10 09:11	vmromanos	Tag Attached: Approved
2015-08-10 09:12	hgbot	Checkin
2015-08-10 09:12	hgbot	Note Added: 0079270
2015-08-10 09:12	hgbot	Status	scheduled => resolved
2015-08-10 09:12	hgbot	Resolution	open => fixed
2015-08-10 09:12	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR15Q2.4/rev/14a82c0a34bd2974fe1836847ea6ec5fd2fd3a0f [^]
2015-08-10 09:12	vmromanos	Review Assigned To	=> vmromanos
2015-08-10 09:12	vmromanos	Status	resolved => closed