Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015731
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2011-01-21 14:382011-02-23 00:00
ReporteregoitzView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionb356fc9b31a7
ProjectionnoneETAnoneTarget Version2.50MP27
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.4Ant version
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015731: 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.
TagsNo tags attached.
Attached Filestxt file icon create_locators.txt [^] (504 bytes) 2011-02-11 13:57 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00159572.50MP27 closedshuehner The locator selector takes long to return the data when there are a lot of locators on the table 

-  Notes
(0034156)
hgbot (developer)
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 (developer)
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 (developer)
2011-02-22 19:03

Verified

- Issue History
Date Modified Username Field Change
2011-01-21 14:38 egoitz New Issue
2011-01-21 14:38 egoitz Assigned To => alostale
2011-01-21 14:38 egoitz Modules => Core
2011-01-24 08:21 alostale Status new => scheduled
2011-01-24 08:21 alostale Assigned To alostale => shuehner
2011-01-24 08:21 alostale fix_in_branch => pi
2011-01-25 13:28 egoitz Issue Monitored: networkb
2011-02-11 13:57 egoitz File Added: create_locators.txt
2011-02-11 17:35 shuehner Status scheduled => acknowledged
2011-02-11 17:35 shuehner fix_in_branch pi =>
2011-02-11 17:35 shuehner Status acknowledged => scheduled
2011-02-11 17:35 shuehner fix_in_branch => pi
2011-02-11 18:07 hgbot Checkin
2011-02-11 18:07 hgbot Note Added: 0034156
2011-02-11 18:07 hgbot Status scheduled => resolved
2011-02-11 18:07 hgbot Resolution open => fixed
2011-02-11 18:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b356fc9b31a7f6cf7519e727096397ba766ad377 [^]
2011-02-11 18:07 hgbot Checkin
2011-02-11 18:07 hgbot Note Added: 0034157
2011-02-22 19:03 marvintm Note Added: 0034324
2011-02-22 19:03 marvintm Status resolved => closed
2011-02-23 00:00 anonymous sf_bug_id 0 => 3189582


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker