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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027101
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementtrivialhave not tried2014-07-16 17:522014-08-08 18:53
ReportergorkaionView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision65baebc38991
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027101: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00270263.0PR15Q2 closededuardo_Argal Poor performance of m_get_stock 
blocks defect 0027160 closededuardo_Argal C_Order_Post poor performance 

-  Notes
(0068672)
hgbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2014-07-16 17:52 gorkaion New Issue
2014-07-16 17:52 gorkaion Assigned To => eduardo_Argal
2014-07-16 17:52 gorkaion Modules => Core
2014-07-16 17:52 gorkaion Triggers an Emergency Pack => No
2014-07-16 17:52 gorkaion Issue generated from 0027026
2014-07-16 17:52 gorkaion Relationship added related to 0027026
2014-07-16 17:54 hgbot Checkin
2014-07-16 17:54 hgbot Note Added: 0068672
2014-07-16 17:54 hgbot Status new => resolved
2014-07-16 17:54 hgbot Resolution open => fixed
2014-07-16 17:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65baebc3899127060b1bb485ef199ff286dcba7b [^]
2014-07-16 17:54 gorkaion Status resolved => closed
2014-07-23 08:28 alostale Relationship added blocks 0027160
2014-08-08 18:53 hudsonbot Checkin
2014-08-08 18:53 hudsonbot Note Added: 0069173


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker