Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0044281 | Openbravo ERP | A. Platform | public | 2020-06-04 11:06 | 2020-07-07 20:18 |
| Reporter | ALopetegui | ||||
| Assigned To | cberner | ||||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | Fixed in Version | PR20Q3 | |||
| Merge Request Status | |||||
| Review Assigned To | alostale | ||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0044281: user window have bad performance because of HQL filter clause | ||||
| Description | The Window User have different query in the Filter clause and in the HQL filter clause. The SQL clause check if the user is an employee or salesrepresentative doing a exists with c_bpartner window and joining with the c_bpart_ner_id of ad_user. The HQL filter instead, makes the check with an "IN" and without joining c_bpartner_id of ad_user. SQL query have a good performance, HQL query not. | ||||
| Steps To Reproduce | In a high volume instance, open the window "user" and search a user filtering by any value. | ||||
| Proposed Solution | Change the HQL query to have the same query as SQL clause Attached diff file. | ||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files |  userWindow.patch (1,092) 2020-06-04 11:06https://issues.openbravo.com/file_download.php?file_id=14571&type=bug | ||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2020-06-04 11:06 | ALopetegui | New Issue | |||
| 2020-06-04 11:06 | ALopetegui | Assigned To | => platform | ||
| 2020-06-04 11:06 | ALopetegui | File Added: userWindow.patch | |||
| 2020-06-04 11:06 | ALopetegui | Modules | => Core | ||
| 2020-06-04 11:06 | ALopetegui | Resolution time | => 1592431200 | ||
| 2020-06-04 11:06 | ALopetegui | Triggers an Emergency Pack | => No | ||
| 2020-06-04 11:06 | ALopetegui | Tag Attached: Performance | |||
| 2020-06-12 11:22 | cberner | Note Added: 0120822 | |||
| 2020-06-12 11:22 | cberner | Assigned To | platform => cberner | ||
| 2020-06-12 11:22 | cberner | Status | new => scheduled | ||
| 2020-06-16 08:14 | hgbot | Checkin | |||
| 2020-06-16 08:14 | hgbot | Note Added: 0120854 | |||
| 2020-06-16 08:14 | hgbot | Status | scheduled => resolved | ||
| 2020-06-16 08:14 | hgbot | Resolution | open => fixed | ||
| 2020-06-16 08:14 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/462fb40027b9cc3ce723cfba74f3a95d51cf3c9e [^] | ||
| 2020-06-16 08:16 | cberner | Review Assigned To | => alostale | ||
| 2020-06-19 07:12 | alostale | Status | resolved => closed | ||
| 2020-06-19 07:12 | alostale | Fixed in Version | => 3.0PR20Q3 | ||
| 2020-07-07 20:18 | eugeni | Issue Monitored: eugeni | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||