Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045723
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2021-01-12 22:272021-01-13 13:22
ReporteregoitzView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionopenFixed in Version
StatusfeedbackFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045723: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker