Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027022Openbravo ERPA. Platformpublic2014-07-07 09:502014-08-08 18:52
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027022: Sequential scans in ad_preference table
DescriptionGet preference value results in sequential scans to ad_preference table
Steps To Reproduce-Execute in DB: select AD_GET_PREFERENCE_VALUE('StockReservations', 'Y', '0', '0', NULL, NULL, NULL);
-Check sequential scans in AD_Preference
Proposed Solution
Additional Information
TagsPerformance
Relationships
blocks defect 0027160 closed eduardo_Argal C_Order_Post poor performance 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-07 09:50alostaleNew Issue
2014-07-07 09:50alostaleAssigned To => alostale
2014-07-07 09:50alostaleOBNetwork customer => No
2014-07-07 09:50alostaleModules => Core
2014-07-07 09:50alostaleTriggers an Emergency Pack => No
2014-07-07 09:51alostaleReview Assigned To => shankarb
2014-07-07 09:54alostaleTag Attached: Performance
2014-07-07 10:00hgbotCheckin
2014-07-07 10:00hgbotNote Added: 0068548
2014-07-07 10:00hgbotStatusnew => resolved
2014-07-07 10:00hgbotResolutionopen => fixed
2014-07-07 10:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c9bd122b07a89adcb2a583af38772bbfcfce7bbd [^]
2014-07-14 10:40shankarbNote Added: 0068607
2014-07-14 10:40shankarbStatusresolved => closed
2014-07-14 10:40shankarbFixed in Version => PR14Q4
2014-07-19 07:59hari_madhavanIssue Monitored: hari_madhavan
2014-07-23 08:26alostaleRelationship addedblocks 0027160
2014-07-23 10:57mtaalIssue Monitored: mtaal
2014-08-08 18:52hudsonbotCheckin
2014-08-08 18:52hudsonbotNote Added: 0069143

Notes
(0068548)
hgbot   
2014-07-07 10:00   
Repository: erp/devel/pi
Changeset: c9bd122b07a89adcb2a583af38772bbfcfce7bbd
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Jul 07 09:59:09 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c9bd122b07a89adcb2a583af38772bbfcfce7bbd [^]

fixed bug 27022: Sequential scans in ad_preference table

---
M src-db/database/model/tables/AD_PREFERENCE.xml
---
(0068607)
shankarb   
2014-07-14 10:40   
Code reviewed and verified in pi changeset 022f33b5b771.
(0069143)
hudsonbot   
2014-08-08 18:52   
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/4450016dee64 [^]
Maturity status: Test