Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0045723Openbravo ERP07. Sales managementpublic2021-01-12 22:272021-01-19 16:18
egoitz 
Triage Omni OMS 
normalmajoralways
closedno change required 
5
 
 
Core
No
0045723: Slowness on the sales order window with thousands of lines
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
- 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.
Create a index on the c_order.ad_org_id column
No tags attached.
Issue History
2021-01-12 22:27egoitzNew Issue
2021-01-12 22:27egoitzAssigned To => Triage Finance
2021-01-12 22:27egoitzModules => Core
2021-01-12 22:27egoitzTriggers an Emergency Pack => No
2021-01-13 13:22dmiguelezStatusnew => feedback
2021-01-19 16:18dmiguelezNote Added: 0125642
2021-01-19 16:18dmiguelezStatusfeedback => closed
2021-01-19 16:18dmiguelezResolutionopen => no change required

Notes
(0125642)
dmiguelez   
2021-01-19 16:18   
Adding this Organization index can be helpful in some particular scenarios for a client, but is not the complete solution.
Also, the complete solution can not be generic enough, so it must be implemented as a customization.

The data retrieved in a Window is previously filtered and ordered.
In order to have the most optimal index, it should consider the columns used to filter and order the data retrieved.

For example, if the data is always filtered by Organization and issotrx, the index should include organization, issotrx and the id.

More information can be found in the wiki entry that explains how to properly configure the grid and add the required indexes:
http://wiki.openbravo.com/wiki/How_to_configure_high_volume_windows [^]