Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025029Openbravo ERPA. Platformpublic2013-10-25 19:512013-10-30 10:22
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP29 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025029: Some queries of LinkedItems have to many to_char calls in them confusing db optimizer making the queries very slow
DescriptionThe 'selectLinks' Method of the UsedByLink_data.xsql file is having a few to_char calls applied to parameters and _id columns.

Those are:
a.) not needed in that case
b.) Confuse at least oracle optimizer in some cases making it not use an index on that column making all the Linked Items calls very slow.
Steps To Reproduce-
Proposed SolutionSimplify query by removing the unnecessary to_char calls.
Additional Information
TagsPerformance
Relationships
related to defect 00005472.40 closed alostale Linked items does not work for tables with double PK 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-25 19:51shuehnerNew Issue
2013-10-25 19:51shuehnerAssigned To => alostale
2013-10-25 19:51shuehnerModules => Core
2013-10-25 19:51shuehnerTriggers an Emergency Pack => No
2013-10-25 19:51shuehnerTag Attached: Performance
2013-10-25 21:51shuehnerRelationship addedrelated to 0000547
2013-10-28 11:05shuehnerReview Assigned To => alostale
2013-10-28 11:05shuehnerAssigned Toalostale => shuehner
2013-10-28 18:48hgbotCheckin
2013-10-28 18:48hgbotNote Added: 0061925
2013-10-28 18:48hgbotCheckin
2013-10-28 18:48hgbotNote Added: 0061926
2013-10-28 18:48hgbotStatusnew => resolved
2013-10-28 18:48hgbotResolutionopen => fixed
2013-10-28 18:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0c5a121a79dd6727dfea4526dae61ea44c9e47e2 [^]
2013-10-29 17:53hudsonbotCheckin
2013-10-29 17:53hudsonbotNote Added: 0061948
2013-10-29 17:53hudsonbotCheckin
2013-10-29 17:53hudsonbotNote Added: 0061949
2013-10-30 10:22alostaleNote Added: 0061961
2013-10-30 10:22alostaleStatusresolved => closed
2013-10-30 10:22alostaleFixed in Version => 3.0MP29

Notes
(0061925)
hgbot   
2013-10-28 18:48   
Repository: erp/devel/pi
Changeset: a1e7b96abcddc19af4da8b6f76830bae2bb41d6d
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Oct 25 15:52:39 2013 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/a1e7b96abcddc19af4da8b6f76830bae2bb41d6d [^]

Issue 25029: Cleanup: delete a few unused,non-public xsql methods

---
M src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---
(0061926)
hgbot   
2013-10-28 18:48   
Repository: erp/devel/pi
Changeset: 0c5a121a79dd6727dfea4526dae61ea44c9e47e2
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Oct 25 15:53:42 2013 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/0c5a121a79dd6727dfea4526dae61ea44c9e47e2 [^]

Fixed 25029: Improve performance of linked items
Remove a few not really needed to_char calls which are confusing oracle
optimizer in at least one case causing it to not use an index where it
could.

---
M src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---
(0061948)
hudsonbot   
2013-10-29 17:53   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f1ae0e6fd033 [^]

Maturity status: Test
(0061949)
hudsonbot   
2013-10-29 17:53   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f1ae0e6fd033 [^]

Maturity status: Test
(0061961)
alostale   
2013-10-30 10:22   
code reviewed + tested