Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002563Openbravo ERPI. Performancepublic2008-01-29 19:182008-11-26 13:55
Reporterjpabloae 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002563: OBN:Performance loss using AD_COLUMN_IDENTIFIER in some sel.
DescriptionPerformance issue:

"In the business partner and business selector, in the select you are using a function called AD_COLUMN_IDENTIFIER. This function, we think slows down the search effort to sometimes unacceptable levels. Is there a specific reason for this function?"

Affected versions: 2.35, 2.35MP1
DB: any
OS: any
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003643 closed alostale OBN:Performance loss using AD_COLUMN_IDENTIFIER  
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-26 13:55psarobeRegression testing => No
2008-11-26 13:55psarobeStatusresolved => closed

Notes
(0006152)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1881978 [^]
(0003109)
cromero   
2008-02-12 13:36   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500614
Originator: NO

Priority level has been decreased by the risk that this task can introduce to the application.
This functionality is an improvement of the performance that must be widely tested before to commit.

Carlos Romero
Openbravo Team
(0003110)
alostale   
2008-02-26 14:18   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1500722
Originator: NO

For this selector it is not necessary to use AD_COLUMN_IDENTIFIER function so it is not used.