Openbravo Issue Tracking System - Openbravo ERP |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0025029 | Openbravo ERP | A. Platform | public | 2013-10-25 19:51 | 2013-10-30 10:22 |
|
Reporter | shuehner | |
Assigned To | shuehner | |
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | fixed | |
Platform | | OS | 5 | OS Version | |
Product Version | | |
Target Version | | Fixed in Version | 3.0MP29 | |
Merge Request Status | |
Review Assigned To | alostale |
OBNetwork customer | No |
Web browser | |
Modules | Core |
Support ticket | |
Regression level | |
Regression date | |
Regression introduced in release | |
Regression introduced by commit | |
Triggers an Emergency Pack | No |
|
Summary | 0025029: Some queries of LinkedItems have to many to_char calls in them confusing db optimizer making the queries very slow |
Description | The '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 Solution | Simplify query by removing the unnecessary to_char calls. |
Additional Information | |
Tags | Performance |
Relationships | related to | defect | 0000547 | 2.40 | closed | alostale | Linked items does not work for tables with double PK |
|
Attached Files | |
|
Issue History |
Date Modified | Username | Field | Change |
2013-10-25 19:51 | shuehner | New Issue | |
2013-10-25 19:51 | shuehner | Assigned To | => alostale |
2013-10-25 19:51 | shuehner | Modules | => Core |
2013-10-25 19:51 | shuehner | OBNetwork customer | => No |
2013-10-25 19:51 | shuehner | Triggers an Emergency Pack | => No |
2013-10-25 19:51 | shuehner | Tag Attached: Performance | |
2013-10-25 21:51 | shuehner | Relationship added | related to 0000547 |
2013-10-28 11:05 | shuehner | Review Assigned To | => alostale |
2013-10-28 11:05 | shuehner | Assigned To | alostale => shuehner |
2013-10-28 18:48 | hgbot | Checkin | |
2013-10-28 18:48 | hgbot | Note Added: 0061925 | |
2013-10-28 18:48 | hgbot | Checkin | |
2013-10-28 18:48 | hgbot | Note Added: 0061926 | |
2013-10-28 18:48 | hgbot | Status | new => resolved |
2013-10-28 18:48 | hgbot | Resolution | open => fixed |
2013-10-28 18:48 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0c5a121a79dd6727dfea4526dae61ea44c9e47e2 [^] |
2013-10-29 17:53 | hudsonbot | Checkin | |
2013-10-29 17:53 | hudsonbot | Note Added: 0061948 | |
2013-10-29 17:53 | hudsonbot | Checkin | |
2013-10-29 17:53 | hudsonbot | Note Added: 0061949 | |
2013-10-30 10:22 | alostale | Note Added: 0061961 | |
2013-10-30 10:22 | alostale | Status | resolved => closed |
2013-10-30 10:22 | alostale | Fixed in Version | => 3.0MP29 |
Notes |
|
(0061925)
|
hgbot
|
2013-10-28 18:48
|
|
|
|
(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
---
|
|
|
|
|
|
|
|
|
|
|