Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0045723 | Openbravo ERP | 07. Sales management | public | 2021-01-12 22:27 | 2021-01-19 16:18 |
Reporter | egoitz | ||||
Assigned To | Triage Omni OMS | ||||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | no change required | ||
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 | 0045723: Slowness on the sales order window with thousands of lines | ||||
Description | The query executed on the sales order grid takes many seconds to be executed and reads few GB per execution on environment with big amount of orders | ||||
Steps To Reproduce | - On an environment with thousands of orders open the grid - See that the query takes few minutes - Check the database statistics and see that many GB are read on the execution. | ||||
Proposed Solution | Create a index on the c_order.ad_org_id column | ||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2021-01-12 22:27 | egoitz | New Issue | |||
2021-01-12 22:27 | egoitz | Assigned To | => Triage Finance | ||
2021-01-12 22:27 | egoitz | Modules | => Core | ||
2021-01-12 22:27 | egoitz | Triggers an Emergency Pack | => No | ||
2021-01-13 13:22 | dmiguelez | Status | new => feedback | ||
2021-01-19 16:18 | dmiguelez | Note Added: 0125642 | |||
2021-01-19 16:18 | dmiguelez | Status | feedback => closed | ||
2021-01-19 16:18 | dmiguelez | Resolution | open => no change required |
Notes | |||||
|
|||||
|
|