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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0125642) dmiguelez (developer) 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 [^]

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