Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0025029 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2013-10-25 19:51 | 2013-10-30 10:22 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0MP29 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 0c5a121a79dd | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| 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. | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0061925) hgbot (developer) 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 (developer) 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 (viewer) 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 (viewer) 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 (viewer) 2013-10-30 10:22 |
code reviewed + tested |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |