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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020419
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2012-05-04 14:352012-05-25 12:09
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchFixed in SCM revision2e2fc5aaf9de
ProjectionnoneETAnoneTarget Version3.0MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020419: 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.
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0020421 closedalostale Review needed indexes 

-  Notes
(0048383)
hgbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2012-05-04 14:35 alostale New Issue
2012-05-04 14:35 alostale Assigned To => alostale
2012-05-04 14:35 alostale Modules => Core
2012-05-04 14:44 hgbot Checkin
2012-05-04 14:44 hgbot Note Added: 0048383
2012-05-04 14:44 hgbot Status new => resolved
2012-05-04 14:44 hgbot Resolution open => fixed
2012-05-04 14:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2e2fc5aaf9deb59d6c038528794d0d3def7947c6 [^]
2012-05-04 14:47 alostale Relationship added related to 0020421
2012-05-04 14:47 alostale Tag Attached: Performance
2012-05-16 09:12 marvintm Status resolved => closed
2012-05-16 09:12 marvintm Fixed in Version => 3.0MP12
2012-05-25 12:09 hudsonbot Checkin
2012-05-25 12:09 hudsonbot Note Added: 0049026


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker