Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0033195 | Openbravo ERP | A. Platform | public | 2016-06-08 16:48 | 2022-02-01 08:05 |
| Reporter | shuehner | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | have not tried |
| Status | acknowledged | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| 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 | 0033195: OBContext.initialize loading many objects from database. Review if some loads can be optimized away | ||||
| Description | Reviewing SQL's done during insert into c_import_entry (i.e. via pos orderloader). All the following SQL's were found to happen and all seems to come from OBContext.initialze (so probably at least once per http request) Example flow starts from ImportEntryProcessor.setOBContext in case context is not yet cached. 1.) via OBContext.initialize() select aduser0_.AD_User_ID select adlanguage0_.AD_Language_ID select adclient0_.AD_Client_ID select adlanguage0_.AD_Language_ID select organizati0_.AD_Org_ID select warehouse0_.M_Warehouse select adrole0_.AD_Role_ID_ select adrole0_.AD_Role_ID select organizati0_.AD_Org_ID select organizati0_.AD_Org_ID select adclient0_.AD_Client_ID select clientinfo0_.AD_Client_ID select count(*) as col_0_0_ from AD_Language Review if all loads are really needed or can be removed. If all are needed maybe some sharing can be done in case input param (id requested is same for several loads of same table). Also the last one (count from ad_language) is checking 'issystemlanguage='Y' which does probably not need to be repeated over and over again | ||||
| Steps To Reproduce | - | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2016-06-08 16:48 | shuehner | New Issue | |||
| 2016-06-08 16:48 | shuehner | Assigned To | => platform | ||
| 2016-06-08 16:48 | shuehner | Modules | => Core | ||
| 2016-06-08 16:48 | shuehner | Triggers an Emergency Pack | => No | ||
| 2016-06-08 16:48 | shuehner | Tag Attached: Performance | |||
| 2016-07-15 09:58 | alostale | Status | new => acknowledged | ||
| 2016-12-01 14:05 | alostale | Priority | normal => urgent | ||
| 2016-12-01 14:05 | alostale | Priority | urgent => high | ||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |