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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0030836
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 02. Master data managementtrivialhave not tried2015-09-16 12:592015-09-21 14:58
ReporterSandrahuguetView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version3.0PR15Q4
StatusclosedFix in branchFixed in SCM revisioned620f87e217
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Tomtaal
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0043274 closedAtulOpenbravo Payment In/Out Window bad performance because documentno index is missing 

-  Notes
(0080431)
Sandrahuguet (developer)
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 (developer)
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 (developer)
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 (manager)
2015-09-21 14:58

Reviewed

- Issue History
Date Modified Username Field Change
2015-09-16 12:59 Sandrahuguet New Issue
2015-09-16 12:59 Sandrahuguet Assigned To => Triage Finance
2015-09-16 12:59 Sandrahuguet Modules => Core
2015-09-16 12:59 Sandrahuguet Triggers an Emergency Pack => No
2015-09-16 13:04 Sandrahuguet Note Added: 0080431
2015-09-16 13:06 Sandrahuguet Note Edited: 0080431 View Revisions
2015-09-16 13:16 Sandrahuguet Review Assigned To => mtaal
2015-09-16 13:16 Sandrahuguet Type defect => feature request
2015-09-16 13:16 Sandrahuguet Note Edited: 0080431 View Revisions
2015-09-16 13:43 hgbot Checkin
2015-09-16 13:43 hgbot Note Added: 0080432
2015-09-16 13:43 hgbot Status new => resolved
2015-09-16 13:43 hgbot Resolution open => fixed
2015-09-16 13:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed620f87e2170ded940e54a3fda9775bab561fe3 [^]
2015-09-16 13:44 Sandrahuguet Assigned To Triage Finance => Sandrahuguet
2015-09-16 20:09 hudsonbot Checkin
2015-09-16 20:09 hudsonbot Note Added: 0080439
2015-09-21 14:58 mtaal Note Added: 0080532
2015-09-21 14:58 mtaal Status resolved => closed
2015-09-21 14:58 mtaal Fixed in Version => 3.0PR15Q4
2020-02-19 18:06 ALopetegui Relationship added related to 0043274


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker