Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027101Openbravo ERP04. Warehouse managementpublic2014-07-16 17:522014-08-08 18:53
Reportergorkaion 
Assigned Toeduardo_Argal 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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
Summary0027101: sequential scans on reservation tables on m_get_stock function execution
DescriptionM_Get_Stock function is performing poorly where there are stock reservations.

It does a full scan on m_reservation_stock.
Steps To ReproduceIn an environment with 7K records in m_reservation and 5K in m_reservation_stock.
-Create a reservation
-process it
-check there is a sequential scan caused by m_get_stock
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00270263.0PR15Q2 closed eduardo_Argal Poor performance of m_get_stock 
blocks defect 0027160 closed eduardo_Argal C_Order_Post poor performance 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-16 17:52gorkaionNew Issue
2014-07-16 17:52gorkaionAssigned To => eduardo_Argal
2014-07-16 17:52gorkaionModules => Core
2014-07-16 17:52gorkaionTriggers an Emergency Pack => No
2014-07-16 17:52gorkaionIssue generated from0027026
2014-07-16 17:52gorkaionRelationship addedrelated to 0027026
2014-07-16 17:54hgbotCheckin
2014-07-16 17:54hgbotNote Added: 0068672
2014-07-16 17:54hgbotStatusnew => resolved
2014-07-16 17:54hgbotResolutionopen => fixed
2014-07-16 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65baebc3899127060b1bb485ef199ff286dcba7b [^]
2014-07-16 17:54gorkaionStatusresolved => closed
2014-07-23 08:28alostaleRelationship addedblocks 0027160
2014-08-08 18:53hudsonbotCheckin
2014-08-08 18:53hudsonbotNote Added: 0069173

Notes
(0068672)
hgbot   
2014-07-16 17:54   
Repository: erp/devel/pi
Changeset: 65baebc3899127060b1bb485ef199ff286dcba7b
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 16 17:53:44 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/65baebc3899127060b1bb485ef199ff286dcba7b [^]

Fixed issue 27101.Add missing indexes.

---
M src-db/database/model/tables/M_RESERVATION.xml
M src-db/database/model/tables/M_RESERVATION_STOCK.xml
---
(0069173)
hudsonbot   
2014-08-08 18: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/4450016dee64 [^]
Maturity status: Test