Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Loyalty Programs for Web POSmajoralways2021-07-12 13:372021-07-22 10:22
ReportermigueldejuanaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionRR21Q4.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0047439: Filter by order in Earn + Burn Transactions could have bad performance.

DescriptionIn the ERP, the window "Earn + Burn Transactions" has a selector or Sales Order to filter transactions. The amount of points transactions is huge and filtering transactions by several order ids is not good in performance.
Steps To Reproduce- Go to ERP
- Open "Earn + Burn Transactions" window
- Filter by Sales order (we must have a DDBB with a lot of transactions)
- ERROR! The performances is not good
Proposed Solution- Create an index in OBLP_EARNED_POINTS for C_ORDER_ID
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0047371 closedmigueldejuana Filter by order in Earn + Burn Transactions could have bad performance. 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-07-22 10:22 migueldejuana Type defect => backport
2021-07-22 10:22 migueldejuana Target Version => RR21Q4.1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker