Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030836Openbravo ERP02. Master data managementpublic2015-09-16 12:592015-09-21 14:58
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version3.0PR15Q4 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030836: [HGVOL] Add indexes to improve performance in standard windows
DescriptionIn order to improve the performance of sorting in some Openbravo windows several indexes should be created.
Below are shown the columns in which the performance of sorting must be improve:

*c_bpartner: name,referenceno, value
*c_order: dateordered, documentno
*m_inout: documentno, movementdate
*m_offer_bpartner: c_bpartner
*m_product: name, upc, value
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0043274 closed AtulOpenbravo Payment In/Out Window bad performance because documentno index is missing 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-09-16 12:59SandrahuguetNew Issue
2015-09-16 12:59SandrahuguetAssigned To => Triage Finance
2015-09-16 12:59SandrahuguetModules => Core
2015-09-16 12:59SandrahuguetTriggers an Emergency Pack => No
2015-09-16 13:04SandrahuguetNote Added: 0080431
2015-09-16 13:06SandrahuguetNote Edited: 0080431bug_revision_view_page.php?bugnote_id=0080431#r9441
2015-09-16 13:16SandrahuguetReview Assigned To => mtaal
2015-09-16 13:16SandrahuguetTypedefect => feature request
2015-09-16 13:16SandrahuguetNote Edited: 0080431bug_revision_view_page.php?bugnote_id=0080431#r9442
2015-09-16 13:43hgbotCheckin
2015-09-16 13:43hgbotNote Added: 0080432
2015-09-16 13:43hgbotStatusnew => resolved
2015-09-16 13:43hgbotResolutionopen => fixed
2015-09-16 13:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed620f87e2170ded940e54a3fda9775bab561fe3 [^]
2015-09-16 13:44SandrahuguetAssigned ToTriage Finance => Sandrahuguet
2015-09-16 20:09hudsonbotCheckin
2015-09-16 20:09hudsonbotNote Added: 0080439
2015-09-21 14:58mtaalNote Added: 0080532
2015-09-21 14:58mtaalStatusresolved => closed
2015-09-21 14:58mtaalFixed in Version => 3.0PR15Q4
2020-02-19 18:06ALopeteguiRelationship addedrelated to 0043274

Notes
(0080431)
Sandrahuguet   
2015-09-16 13:04   
(edited on: 2015-09-16 13:16)
In an environment with 1000000 of products:
 *Order by "name" column in "Product" window: 4.96s

After creating the index "C_BPARTNER_NAME_ID"
 *Order by "name" column in "Product" window: 95ms
(0080432)
hgbot   
2015-09-16 13:43   
Repository: erp/devel/pi
Changeset: ed620f87e2170ded940e54a3fda9775bab561fe3
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Sep 14 12:49:49 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ed620f87e2170ded940e54a3fda9775bab561fe3 [^]

Fixed issue 30836 Added indexes to improve performance in ob windows

---
M src-db/database/model/tables/C_BPARTNER.xml
M src-db/database/model/tables/C_ORDER.xml
M src-db/database/model/tables/M_INOUT.xml
M src-db/database/model/tables/M_OFFER_BPARTNER.xml
M src-db/database/model/tables/M_PRODUCT.xml
---
(0080439)
hudsonbot   
2015-09-16 20:09   
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/d8c7e392b8b3 [^]
Maturity status: Test
(0080532)
mtaal   
2015-09-21 14:58   
Reviewed