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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035662
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2017-03-30 17:272017-05-29 17:43
ReporterSandrahuguetView Statuspublic 
Assigned Tomarkmm82 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision4f2d5a272565
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035662: Open the business partner selector in financial account window takes too long in hgvol environment

DescriptionOpen the business partner selector in financial account window takes too long in hgvol environment (20000000 bps)
Steps To Reproduce-Login in the ERP
-Go to financial Account window
-Open business partner selector, notice that takes more that 9m
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00202573.0MP12 closedAugustoMauch The partner selector takes long to show data having more than 600k partners 
related to defect 00178383.0MP3 closeddalsasua The Business Partner selector in Financial Account has mark Customer as yes by default 

-  Notes
(0096028)
hgbot (developer)
2017-04-12 13:22

 Repository: erp/devel/pi
Changeset: 4f2d5a272565170f11087b0a773e344b0c080672
Author: Mark <markmm82 <at> gmail.com>
Date: Wed Apr 12 13:18:21 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4f2d5a272565170f11087b0a773e344b0c080672 [^]

Fixes issue 35662: Improve performance of BP selector in FA window

Improve performance of Business Partner selector in Financial Account window.
"Business Partner selector without default expressions" will be used instead of "Business Partner not filtered by default by customer/vendor" as Business Partner selector in Financial Account window in Account and Bank Statement Lines tabs.
Thus, we take advantage of c_bpartner_name_id index.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0096029)
aferraz (manager)
2017-04-12 13:23

 Code review + Testing OK
(0096889)
hudsonbot (developer)
2017-05-29 17:43

 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/1ee70113bdc4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-03-30 17:27 Sandrahuguet New Issue
2017-03-30 17:27 Sandrahuguet Assigned To => Triage Finance
2017-03-30 17:27 Sandrahuguet Modules => Core
2017-03-30 17:27 Sandrahuguet Triggers an Emergency Pack => No
2017-03-30 17:32 Sandrahuguet Tag Attached: Performance
2017-03-30 17:38 Sandrahuguet Resolution time => 1492639200
2017-03-30 20:13 markmm82 Assigned To Triage Finance => markmm82
2017-03-30 20:15 markmm82 Status new => acknowledged
2017-04-04 23:04 markmm82 Status acknowledged => scheduled
2017-04-07 10:11 Sandrahuguet Description Updated View Revisions
2017-04-07 13:27 aferraz Relationship added related to 0020257
2017-04-07 13:29 aferraz Relationship added related to 0017838
2017-04-12 13:22 hgbot Checkin
2017-04-12 13:22 hgbot Note Added: 0096028
2017-04-12 13:22 hgbot Status scheduled => resolved
2017-04-12 13:22 hgbot Resolution open => fixed
2017-04-12 13:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4f2d5a272565170f11087b0a773e344b0c080672 [^]
2017-04-12 13:23 aferraz Review Assigned To => aferraz
2017-04-12 13:23 aferraz Note Added: 0096029
2017-04-12 13:23 aferraz Status resolved => closed
2017-04-12 13:23 aferraz Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096889

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker