Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020419Openbravo ERPA. Platformpublic2012-05-04 14:352012-05-25 12:09
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP12Fixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020419: Missing indexes
DescriptionIn an environment with big volume of data, some indexes have been detected to be needed to improve performance
Steps To Reproduce*c_bp_vendor_acct.c_bpartner_id. Reduces invoice post from 4s to 700ms
*fin_payment_schedule.c_invoice_id, fin_payment_detail.fin_payment_id, fin_payment_scheduledetail.fin_payment_detail_id. These indexes reduce invoice post from 600 to 500ms
*c_file (ad_table_id, ad_record_id). Removes a sequencial scan in c_file for each record selected in ui.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to design defect 0020421 closed alostale Review needed indexes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-04 14:35alostaleNew Issue
2012-05-04 14:35alostaleAssigned To => alostale
2012-05-04 14:35alostaleModules => Core
2012-05-04 14:44hgbotCheckin
2012-05-04 14:44hgbotNote Added: 0048383
2012-05-04 14:44hgbotStatusnew => resolved
2012-05-04 14:44hgbotResolutionopen => fixed
2012-05-04 14:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2e2fc5aaf9deb59d6c038528794d0d3def7947c6 [^]
2012-05-04 14:47alostaleRelationship addedrelated to 0020421
2012-05-04 14:47alostaleTag Attached: Performance
2012-05-16 09:12marvintmStatusresolved => closed
2012-05-16 09:12marvintmFixed in Version => 3.0MP12
2012-05-25 12:09hudsonbotCheckin
2012-05-25 12:09hudsonbotNote Added: 0049026

Notes
(0048383)
hgbot   
2012-05-04 14:44   
Repository: erp/devel/pi
Changeset: 2e2fc5aaf9deb59d6c038528794d0d3def7947c6
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri May 04 14:44:31 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2e2fc5aaf9deb59d6c038528794d0d3def7947c6 [^]

fixes bug 20419: Missing some indexes

---
M src-db/database/model/tables/C_BP_VENDOR_ACCT.xml
M src-db/database/model/tables/C_FILE.xml
M src-db/database/model/tables/FIN_PAYMENT_DETAIL.xml
M src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
M src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml
---
(0049026)
hudsonbot   
2012-05-25 12: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/5401e185a8b0 [^]

Maturity status: Test