Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045723Openbravo ERP07. Sales managementpublic2021-01-12 22:272021-01-19 16:18
Reporteregoitz 
Assigned ToTriage Omni OMS 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045723: Slowness on the sales order window with thousands of lines
DescriptionThe 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 SolutionCreate a index on the c_order.ad_org_id column
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-01-12 22:27egoitzNew Issue
2021-01-12 22:27egoitzAssigned To => Triage Finance
2021-01-12 22:27egoitzOBNetwork customer => Gold
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 [^]