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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0046437
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2021-04-30 12:242021-05-04 12:15
Reportersalvador_campanellaView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionopenFixed in Version
StatusnewFix 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

0046437: Aging report have low performance when is executed in an environment with a huge amount of information

DescriptionAging report have low performance when is executed in an environment with a huge amount of information

The query related with SqlMethod name="selectCredit" is having a low performance
https://gitlab.com/openbravo/devel/openbravo/-/blob/master/src/org/openbravo/erpCommon/ad_reports/AgingDao_data.xsql [^]

Steps To ReproduceExecute the aging report in an environment with a huge amount of information
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0127736)
vmromanos (developer)
2021-05-03 12:33

Please provide the explain plan to properly understand the problem.
(0127753)
salvador_campanella (developer)
2021-05-03 17:46

Sure, Let me share some plans with you:

1.- Aging Credit - Many loops due joins
https://explain.dalibo.com/plan/zvR [^]


2.-Aging Credit Native: https://explain.dalibo.com/plan/QFY [^]
3.-Aging Credit Custom: https://explain.dalibo.com/plan/ETb [^]

- Issue History
Date Modified Username Field Change
2021-04-30 12:24 salvador_campanella New Issue
2021-04-30 12:24 salvador_campanella Assigned To => Triage Finance
2021-04-30 12:24 salvador_campanella Modules => Core
2021-04-30 12:24 salvador_campanella Triggers an Emergency Pack => No
2021-04-30 15:59 ahernandezgil Issue Monitored: ahernandezgil
2021-05-03 12:33 vmromanos Note Added: 0127736
2021-05-03 12:33 vmromanos Assigned To Triage Finance => salvador_campanella
2021-05-03 12:33 vmromanos Status new => feedback
2021-05-03 17:46 salvador_campanella Note Added: 0127753
2021-05-03 17:46 salvador_campanella Note View State: public: 127753
2021-05-04 12:15 vmromanos Assigned To salvador_campanella => Triage Finance
2021-05-04 12:15 vmromanos Status feedback => new


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker