Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0025539 | Openbravo ERP | 09. Financial management | public | 2014-01-22 18:45 | 2014-02-12 18:29 |
|
| Reporter | egoitz | |
| Assigned To | jonalegriaesarte | |
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR14Q2 | Fixed in Version | 3.0PR14Q2 | |
| Merge Request Status | |
| Review Assigned To | egoitz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 26033 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0025539: Performance problems when importing bank statments |
| Description | When there are thousends of partners with similar name performance problems could happen due to the use of .list methods to get the partners.
This happens when there are thousends of partner that has a name similar than a partner used on the bank statement file being imported.
|
| Steps To Reproduce | -Create thousends of partner with a similar name (at least one of the worlds contained on the name idential) than a partner cointained on a bank statment file
-Import the file
-With only 1024mb of Xmx the process does not finish. |
| Proposed Solution | Attached a proposal solution
Don't execute .list() but use ScrollableREsults |
| Additional Information | |
| Tags | Performance |
| Relationships | |
| Attached Files |  importbank.diff (4,105) 2014-01-23 12:42
https://issues.openbravo.com/file_download.php?file_id=6653&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-01-22 18:45 | egoitz | New Issue | |
| 2014-01-22 18:45 | egoitz | Assigned To | => dmiguelez |
| 2014-01-22 18:45 | egoitz | File Added: importbank.diff | |
| 2014-01-22 18:45 | egoitz | Modules | => Core |
| 2014-01-22 18:45 | egoitz | OBNetwork customer | => Yes |
| 2014-01-22 18:45 | egoitz | Triggers an Emergency Pack | => No |
| 2014-01-22 18:45 | egoitz | Tag Attached: Performance | |
| 2014-01-22 18:51 | egoitz | Support ticket | => 26033 |
| 2014-01-22 18:51 | egoitz | Resolution time | => 1391986800 |
| 2014-01-22 18:51 | egoitz | Assigned To | dmiguelez => jonalegriaesarte |
| 2014-01-22 18:51 | egoitz | Target Version | => 3.0MP32 |
| 2014-01-23 09:45 | shuehner | Issue Monitored: shuehner | |
| 2014-01-23 12:42 | egoitz | File Deleted: importbank.diff | |
| 2014-01-23 12:42 | egoitz | File Added: importbank.diff | |
| 2014-02-03 14:00 | hgbot | Checkin | |
| 2014-02-03 14:00 | hgbot | Note Added: 0063863 | |
| 2014-02-03 14:00 | hgbot | Status | new => resolved |
| 2014-02-03 14:00 | hgbot | Resolution | open => fixed |
| 2014-02-03 14:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/148268ee942b0282f40285e4d27d9859d681a01d [^] |
| 2014-02-03 16:51 | egoitz | Review Assigned To | => egoitz |
| 2014-02-03 16:51 | egoitz | Note Added: 0063867 | |
| 2014-02-03 16:51 | egoitz | Status | resolved => closed |
| 2014-02-03 16:51 | egoitz | Fixed in Version | => 3.0MP32 |
| 2014-02-12 18:29 | hudsonbot | Checkin | |
| 2014-02-12 18:29 | hudsonbot | Note Added: 0064149 | |