0025161: Alert Management window's link's bad performance

0025161

Openbravo ERP

A. Platform

public

2013-11-15 01:29

2013-12-18 11:44

Reporter

jonalegriaesarte

Assigned To

shankarb

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Merge Request Status

Review Assigned To

AugustoMauch

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0025161: Alert Management window's link's bad performance

Description

There is an issue with the Alert Management window where the link to a specific record would cause an expensive query to fire. For example, if you had
an alert that referenced a specific sales order and you clicked on the link to navigate to that order, then the following query would be executed twice
and the query does not have any limit:

select order0_.C_Order_ID as col_0_0_
from C_Order order0_, C_DocType documentty1_
where order0_.C_DocTypeTarget_ID=documentty1_.C_DocType_ID
and order0_.IsSOTrx='Y'
and documentty1_.IsReturn='N'
and (documentty1_.DocSubTypeSO not like 'OB')
and (order0_.AD_Org_ID in ('20061' , '20063' , '20062' , '20003' , '20002' , '20023' , '20022' , '20025' , '20001' , '20026' , '20064' , '20065' ,
'20066' , '20067' , '20068' , '20052' , '20051' , '20012' , '20011' , '0' , '20016' , '20015' , '20055' , '20056' , '20053' , '20054'))
and (order0_.AD_Client_ID in ('1969' , '0'))
order by order0_.DocumentNo, order0_.C_Order_ID

The function that is used to open the window is : openDirectTab

So, all the function to open tabs and windows should be checked and fixed in order to improve the performance.

Steps To Reproduce

There is an issue with the Alert Management window where the link to a specific record would cause an expensive query to fire. For example, if you had
an alert that referenced a specific sales order and you clicked on the link to navigate to that order, then the following query would be executed twice
and the query does not have any limit:

select order0_.C_Order_ID as col_0_0_
from C_Order order0_, C_DocType documentty1_
where order0_.C_DocTypeTarget_ID=documentty1_.C_DocType_ID
and order0_.IsSOTrx='Y'
and documentty1_.IsReturn='N'
and (documentty1_.DocSubTypeSO not like 'OB')
and (order0_.AD_Org_ID in ('20061' , '20063' , '20062' , '20003' , '20002' , '20023' , '20022' , '20025' , '20001' , '20026' , '20064' , '20065' ,
'20066' , '20067' , '20068' , '20052' , '20051' , '20012' , '20011' , '0' , '20016' , '20015' , '20055' , '20056' , '20053' , '20054'))
and (order0_.AD_Client_ID in ('1969' , '0'))
order by order0_.DocumentNo, order0_.C_Order_ID

The function that is used to open the window is : openDirectTab

So, all the function to open tabs and windows should be checked and fixed in order to improve the performance.

Proposed Solution

Additional Information

Tags

Performance

Relationships

related to	defect	0025159	3.0MP31	closed	shankarb	Bad performance executing openView function
related to	defect	0025136		closed	shankarb	Linked items navigation not working as expected (3d level subtab)