Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009897Openbravo ERPA. Platformpublic2009-07-14 17:462009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
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
Summary0009897: Business Partner selector is slow with many business partners
DescriptionThis selector is slow with many business partners in the db. (i.e. 50k-100k)
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP3releasecandidate, leo
Relationships
depends on backport 0009898 closed shuehner Business Partner selector is slow with many business partners 
related to defect 0035636 closed markmm82 Business partner selector get stuck in create lines from invoice in hgvol environment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-14 17:46shuehnerNew Issue
2009-07-14 17:46shuehnerAssigned To => shuehner
2009-07-14 17:46shuehnerStatusnew => scheduled
2009-07-14 17:46shuehnerfix_in_branch => pi
2009-07-14 17:59hgbotCheckin
2009-07-14 17:59hgbotNote Added: 0018233
2009-07-14 17:59hgbotStatusscheduled => resolved
2009-07-14 17:59hgbotResolutionopen => fixed
2009-07-14 17:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bfea2c5bcf42377d76be37abbf816eeb3c763c7f [^]
2009-07-14 19:02shuehnerNote Added: 0018236
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 06:20elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825616
2017-04-12 14:08aferrazRelationship addedrelated to 0035636

Notes
(0018233)
hgbot   
2009-07-14 17:59   
Repository: erp/devel/pi
Changeset: bfea2c5bcf42377d76be37abbf816eeb3c763c7f
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Jul 14 17:57:59 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bfea2c5bcf42377d76be37abbf816eeb3c763c7f [^]

Fixed 9897: Improve performance of business partner selector
- optimize with limit/rownum <= 2when called with command=KEY (input value and press enter on calling page) to not load all possible rows when input value of not selective
- optimized placement of limit/offset and rownum

---
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
---
(0018236)
shuehner   
2009-07-14 19:02   
Testing needed:

Testing for direct invocation:
Goto Sales Order
Create a new one
Enter a bp-searchkey into the bpartner field and press enter to open the selector. Three values to test (one leading to no records found, one leading to >1 records found (both should open selector and leave it open), one leading to exactly one record found (selector popup should open and close immediately and use the one record found

General testing:
testing of filtering/sorting of business partner selector