Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009897 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-07-14 17:46 | 2009-07-23 00:00 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | bfea2c5bcf42 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009897: Business Partner selector is slow with many business partners | |||||||
| Description | This selector is slow with many business partners in the db. (i.e. 50k-100k) | |||||||
| Tags | 250MP3releasecandidate, leo | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0018233) hgbot (developer) 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 (administrator) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-14 17:46 | shuehner | New Issue | |
| 2009-07-14 17:46 | shuehner | Assigned To | => shuehner |
| 2009-07-14 17:46 | shuehner | Status | new => scheduled |
| 2009-07-14 17:46 | shuehner | fix_in_branch | => pi |
| 2009-07-14 17:59 | hgbot | Checkin | |
| 2009-07-14 17:59 | hgbot | Note Added: 0018233 | |
| 2009-07-14 17:59 | hgbot | Status | scheduled => resolved |
| 2009-07-14 17:59 | hgbot | Resolution | open => fixed |
| 2009-07-14 17:59 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bfea2c5bcf42377d76be37abbf816eeb3c763c7f [^] |
| 2009-07-14 19:02 | shuehner | Note Added: 0018236 | |
| 2009-07-21 16:24 | psarobe | Fixed in Version | => 2.50MP3 |
| 2009-07-21 16:26 | psarobe | Tag Attached: 250MP3releasecandidate | |
| 2009-07-21 18:43 | psarobe | Tag Attached: leo | |
| 2009-07-22 06:20 | elopio | Status | resolved => closed |
| 2009-07-23 00:00 | anonymous | sf_bug_id | 0 => 2825616 |
| 2017-04-12 14:08 | aferraz | Relationship added | related to 0035636 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |