Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015731Openbravo ERPA. Platformpublic2011-01-21 14:382011-02-23 00:00
Reporteregoitz 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP25 
Target Version2.50MP27Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015731: The locator selector takes long to return the data when there are a lot of locators on the table
DescriptionThe locator selector takes long to return the data when there are a lot of locators on the table, for example with 9000 locators.
Steps To Reproduce-Create 9000 locators. you can use the attached function
-Go to Goods receipt lines.
-Open de selector locator
* it takes long to show the result
Proposed Solutionit seems that the following column on the select is not used.
REPLACE(AD_COLUMN_IDENTIFIER(TO_CHAR('M_LOCATOR'), TO_CHAR(m.M_LOCATOR_ID), TO_CHAR(?)), '''', chr(92)||'''') AS VALUE_HIDDEN

Maybe it is possible to remove it.
You will need also to remove the language parameter and the parameter on the java where the select is used.

Maybe an index could be created on the table.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00159572.50MP27 closed shuehner The locator selector takes long to return the data when there are a lot of locators on the table 
Attached Filestxt create_locators.txt (504) 2011-02-11 13:57
https://issues.openbravo.com/file_download.php?file_id=3584&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-01-21 14:38egoitzNew Issue
2011-01-21 14:38egoitzAssigned To => alostale
2011-01-21 14:38egoitzModules => Core
2011-01-24 08:21alostaleStatusnew => scheduled
2011-01-24 08:21alostaleAssigned Toalostale => shuehner
2011-01-24 08:21alostalefix_in_branch => pi
2011-01-25 13:28egoitzIssue Monitored: networkb
2011-02-11 13:57egoitzFile Added: create_locators.txt
2011-02-11 17:35shuehnerStatusscheduled => acknowledged
2011-02-11 17:35shuehnerfix_in_branchpi =>
2011-02-11 17:35shuehnerStatusacknowledged => scheduled
2011-02-11 17:35shuehnerfix_in_branch => pi
2011-02-11 18:07hgbotCheckin
2011-02-11 18:07hgbotNote Added: 0034156
2011-02-11 18:07hgbotStatusscheduled => resolved
2011-02-11 18:07hgbotResolutionopen => fixed
2011-02-11 18:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b356fc9b31a7f6cf7519e727096397ba766ad377 [^]
2011-02-11 18:07hgbotCheckin
2011-02-11 18:07hgbotNote Added: 0034157
2011-02-22 19:03marvintmNote Added: 0034324
2011-02-22 19:03marvintmStatusresolved => closed
2011-02-23 00:00anonymoussf_bug_id0 => 3189582

Notes
(0034156)
hgbot   
2011-02-11 18:07   
Repository: erp/devel/pi
Changeset: b356fc9b31a7f6cf7519e727096397ba766ad377
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Feb 11 17:36:54 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b356fc9b31a7f6cf7519e727096397ba766ad377 [^]

Fixed 15731. Fix performance issue in locator selector.
Remove a column which has an expensive function call from the select, as it was
just not used.

---
M src/org/openbravo/erpCommon/info/Locator.java
M src/org/openbravo/erpCommon/info/Locator_data.xsql
---
(0034157)
hgbot   
2011-02-11 18:07   
Repository: erp/devel/pi
Changeset: 83f81d4ac28005aa428605a4bc4cdfbb4191484b
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Feb 11 17:41:28 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/83f81d4ac28005aa428605a4bc4cdfbb4191484b [^]

Issue 15731. Do some cleanup.
- Locator.java:
  - remove some unused code/comments
  - convert use of printStacktrace to log4j
- Project.java
  - remove some unused code/comments
  - convert use of printStacktrace to log4j
- Project_java.xsql
  - remove to resultset columns which are not used

---
M src/org/openbravo/erpCommon/info/Locator.java
M src/org/openbravo/erpCommon/info/Project.java
M src/org/openbravo/erpCommon/info/Project_data.xsql
---
(0034324)
marvintm   
2011-02-22 19:03   
Verified