Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023892Openbravo ERPA. Platformpublic2013-05-23 01:392013-05-27 13:27
Reporteregoitz 
Assigned Toshankarb 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP24 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023892: Index missing on fin_payment_schedule table
DescriptionThe following index is missing:

CREATE INDEX fin_paym_sch_ord_idx
  ON fin_payment_schedule
  USING btree
  (c_order_id );

Steps To ReproduceCheck the tables acceses sequencialy when completing a order before and after create the index
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-23 01:39egoitzNew Issue
2013-05-23 01:39egoitzAssigned To => AugustoMauch
2013-05-23 01:39egoitzModules => Core
2013-05-23 01:39egoitzTriggers an Emergency Pack => No
2013-05-23 01:39egoitzTag Attached: Performance
2013-05-23 06:07shankarbAssigned ToAugustoMauch => shankarb
2013-05-23 08:26shankarbReview Assigned To => AugustoMauch
2013-05-23 08:26shankarbIssue Monitored: AugustoMauch
2013-05-23 08:26shankarbStatusnew => scheduled
2013-05-23 08:26shankarbfix_in_branch => pi
2013-05-23 08:27hgbotCheckin
2013-05-23 08:27hgbotNote Added: 0058883
2013-05-23 08:27hgbotStatusscheduled => resolved
2013-05-23 08:27hgbotResolutionopen => fixed
2013-05-23 08:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ba62d08c24113b9701f063d9d61290755cec8fba [^]
2013-05-24 01:19hudsonbotCheckin
2013-05-24 01:19hudsonbotNote Added: 0058915
2013-05-27 13:27AugustoMauchNote Added: 0058952
2013-05-27 13:27AugustoMauchStatusresolved => closed
2013-05-27 13:27AugustoMauchFixed in Version => 3.0MP24

Notes
(0058883)
hgbot   
2013-05-23 08:27   
Repository: erp/devel/pi
Changeset: ba62d08c24113b9701f063d9d61290755cec8fba
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu May 23 11:07:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ba62d08c24113b9701f063d9d61290755cec8fba [^]

Fixes Issue 23892 : Index missing on Fin_Payment_Schedule table.

Added an index for c_order_id field in Fin_Payment_Schedule table.

---
M src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
---
(0058915)
hudsonbot   
2013-05-24 01:19   
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/758b27652865 [^]

Maturity status: Test
(0058952)
AugustoMauch   
2013-05-27 13:27   
Code reviewed and verified in pi@20388faf6420