Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020247Openbravo ERPI. Performancepublic2012-04-12 10:172012-04-26 16:41
Reporteregoitz 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP11 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020247: Long time to load order or invoices windows when having 600k partners
DescriptionLong time to load order or invoices windows when having 600k partners.
The problem is on the salesrep combo that requires time to calculate all the elements to be shown on the combo.
Steps To Reproduce-Create 600.000 partners
-Open the purchase invoice window and click on new
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035922 closed Sandrahuguet It is better for performance to change columns order in c_bpartner_idsalesrep index 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-12 10:17egoitzNew Issue
2012-04-12 10:17egoitzAssigned To => egoitz
2012-04-12 10:17egoitzModules => Core
2012-04-12 10:17egoitzOBNetwork customer => Yes
2012-04-12 10:37hgbotCheckin
2012-04-12 10:37hgbotNote Added: 0047498
2012-04-12 10:37hgbotStatusnew => resolved
2012-04-12 10:37hgbotResolutionopen => fixed
2012-04-12 10:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/38f553ae97a30e7e41fb0e95485a1a5ad787c2e8 [^]
2012-04-17 05:31hudsonbotCheckin
2012-04-17 05:31hudsonbotNote Added: 0047630
2012-04-26 16:41jonalegriaesarteNote Added: 0048046
2012-04-26 16:41jonalegriaesarteStatusresolved => closed
2012-04-26 16:41jonalegriaesarteFixed in Version => 3.0MP11
2017-05-04 15:37SandrahuguetRelationship addedrelated to 0035922

Notes
(0047498)
hgbot   
2012-04-12 10:37   
Repository: erp/devel/pi
Changeset: 38f553ae97a30e7e41fb0e95485a1a5ad787c2e8
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu Apr 12 10:21:28 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/38f553ae97a30e7e41fb0e95485a1a5ad787c2e8 [^]

Fixed Issue 20247. Performance problem loading invoice window with 600k partners

---
M src-db/database/model/tables/AD_USER.xml
M src-db/database/model/tables/C_BPARTNER.xml
---
(0047630)
hudsonbot   
2012-04-17 05:31   
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/cedf57621434 [^]

Maturity status: Test
(0048046)
jonalegriaesarte   
2012-04-26 16:41   
Verified in customer environments.