Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0020301 | Openbravo ERP | A. Platform | public | 2012-04-18 13:06 | 2012-05-25 12:10 |
|
| Reporter | egoitz | |
| Assigned To | AugustoMauch | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0MP9 | |
| Target Version | 3.0MP12 | Fixed in Version | 3.0MP12 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0020301: Bad performance on the old partner selector used on Openbravo 3 on manual forms |
| Description | Bad performance on the old partner selector used on Openbravo 3 on manual forms.
With a big amount of data the select take about 1 minute to be executed so after 15 seconds the selecotr showns an error saying that the server is taking too much to return data. |
| Steps To Reproduce | -Add 500.000 partners.
-Go to "create shipments from order window"
-Open the selector
* after about 15 sencods you get an error.
|
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0020257 | 3.0MP12 | closed | AugustoMauch | The partner selector takes long to show data having more than 600k partners |
|
| Attached Files |  issue20301.diff (7,942) 2012-04-19 10:21
https://issues.openbravo.com/file_download.php?file_id=5146&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-04-18 13:06 | egoitz | New Issue | |
| 2012-04-18 13:06 | egoitz | Assigned To | => AugustoMauch |
| 2012-04-18 13:06 | egoitz | Modules | => Core |
| 2012-04-18 13:06 | egoitz | OBNetwork customer | => Yes |
| 2012-04-18 13:06 | egoitz | Relationship added | related to 0020257 |
| 2012-04-18 13:10 | egoitz | Priority | urgent => immediate |
| 2012-04-18 13:24 | egoitz | Note Added: 0047694 | |
| 2012-04-19 10:21 | marvintm | File Added: issue20301.diff | |
| 2012-04-19 10:22 | marvintm | Note Added: 0047732 | |
| 2012-04-23 18:28 | AugustoMauch | Tag Attached: Performance | |
| 2012-05-08 14:01 | hgbot | Checkin | |
| 2012-05-08 14:01 | hgbot | Note Added: 0048448 | |
| 2012-05-08 14:01 | hgbot | Status | new => resolved |
| 2012-05-08 14:01 | hgbot | Resolution | open => fixed |
| 2012-05-08 14:01 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/606b9a33cf29f2ca3cd2693ff3c40b178136e8f2 [^] |
| 2012-05-08 15:27 | hgbot | Checkin | |
| 2012-05-08 15:27 | hgbot | Note Added: 0048453 | |
| 2012-05-16 09:33 | marvintm | Status | resolved => closed |
| 2012-05-16 09:33 | marvintm | Fixed in Version | => 3.0MP12 |
| 2012-05-25 12:10 | hudsonbot | Checkin | |
| 2012-05-25 12:10 | hudsonbot | Note Added: 0049050 | |
| 2012-05-25 12:10 | hudsonbot | Checkin | |
| 2012-05-25 12:10 | hudsonbot | Note Added: 0049052 | |
|
Notes |
|
|
(0047694)
|
|
egoitz
|
|
2012-04-18 13:24
|
|
The problem in this case happens also with not too much partners but when some of that partners is assigned in a lot of users on ad_user.c_bpartner_id column.
for example:
1500 partner
1300 user
2300 partner_location
but
There are 171 user with one of the partners
ohter 98 users with other partner
and also 13 users with other partner assgiend. |
|
|
|
|
|
I've attached a patch which fixes the issue. It will not be pushed to pi until MP12, because we consider it a risky change. |
|
|
|
(0048448)
|
|
hgbot
|
|
2012-05-08 14:01
|
|
Repository: erp/devel/pi
Changeset: 606b9a33cf29f2ca3cd2693ff3c40b178136e8f2
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue May 08 14:00:10 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/606b9a33cf29f2ca3cd2693ff3c40b178136e8f2 [^]
Fixes issue 20301: Performance improved on the old bp selector
The SQL query used by the business manual windows business partner selector has been modified to improve its performance. The returned rows do not differ to the ones returned by the previoues version of the selector, there has been only an improval in the performance.
---
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
---
|
|
|
|
(0048453)
|
|
hgbot
|
|
2012-05-08 15:27
|
|
Repository: erp/devel/pi
Changeset: 4f58310ab36cbf5faf8394b2b0f62881589646ec
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue May 08 15:27:17 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4f58310ab36cbf5faf8394b2b0f62881589646ec [^]
Related to issue 20301: Fixed Oracle incompatibility.
The xsql of the Business Partner selector was using a query that was compatible with PostgreSQL but not with (WHERE u is null), being 'u' the alias of a table. It has been changed to (WHERE u.isactive is null), which works for PostgreSQL and Oracle.
---
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
---
|
|
|
|
|
|
|
|
|
|