Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018313 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2011-08-18 13:52 | 2011-10-12 01:58 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 7e3fb4e2e7d4 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP4 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP2 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 12351 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018313: Bad performance of the partner selector having arround 100.000 partners | |||||||
| Description | In an application with arround 100.000 partners, the partner selector takes long to show the information, and also so filter data. | |||||||
| Steps To Reproduce | -Enter 100.000 partners with location on the partner table. (you can use idl or a database script. -Go to sales invoice. -Create a new invoice -Open de partner selector. *It takes long to show and filter the data. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0041061) hgbot (developer) 2011-09-19 11:47 |
Repository: erp/devel/pi Changeset: 7e3fb4e2e7d47d19406164738be63882fb51bde2 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Mon Sep 19 11:46:47 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/7e3fb4e2e7d47d19406164738be63882fb51bde2 [^] Fixed issue 18313. Performance of the Business partner selector has been improved. A big improvement has been made by removing the count which (obviously) included retrieving all the selected records. However, although the selector is now usable, performance is still not ideal. To further improve it, separating the selector into multiple ones (ie. not having a business partner/business partner location/ business partner attributes selector) should be considered, because the custom query (which includes a 'distinct' operator) is what is currently killing performance. --- M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ReadOnlyDataSourceService.java M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java --- |
|
(0041192) egoitz (viewer) 2011-09-21 12:19 |
verified |
|
(0041672) hudsonbot (viewer) 2011-10-12 01:58 |
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/9bd2b5c2d982 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-08-18 13:52 | egoitz | New Issue | |
| 2011-08-18 13:52 | egoitz | Assigned To | => alostale |
| 2011-08-18 13:52 | egoitz | Modules | => Core |
| 2011-08-18 13:52 | egoitz | OBNetwork customer | => Yes |
| 2011-08-18 13:54 | egoitz | Support ticket | => 12351 |
| 2011-08-18 13:54 | egoitz | Resolution time | => 1315951200 |
| 2011-08-29 13:06 | alostale | Relationship added | related to 0018107 |
| 2011-08-29 13:07 | egoitz | Target Version | 2.50MP33 => 3.0RC4 |
| 2011-08-29 13:08 | egoitz | Target Version | 3.0RC4 => 3.0MP4 |
| 2011-09-15 13:44 | jonalegriaesarte | Assigned To | alostale => marvintm |
| 2011-09-15 13:45 | jonalegriaesarte | Priority | urgent => immediate |
| 2011-09-19 11:47 | hgbot | Checkin | |
| 2011-09-19 11:47 | hgbot | Note Added: 0041061 | |
| 2011-09-19 11:47 | hgbot | Status | new => resolved |
| 2011-09-19 11:47 | hgbot | Resolution | open => fixed |
| 2011-09-19 11:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7e3fb4e2e7d47d19406164738be63882fb51bde2 [^] |
| 2011-09-21 12:19 | egoitz | Note Added: 0041192 | |
| 2011-09-21 12:19 | egoitz | Status | resolved => closed |
| 2011-09-21 12:19 | egoitz | Fixed in Version | => 3.0MP4 |
| 2011-10-12 01:58 | hudsonbot | Checkin | |
| 2011-10-12 01:58 | hudsonbot | Note Added: 0041672 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |