Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047371Retail ModulesLoyalty Programs for Web POSpublic2021-07-12 13:372021-07-22 10:22
Reportermigueldejuana 
Assigned Tomigueldejuana 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047371: 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
Additional Information
TagsNOR
Relationships
related to defect 0047379 closed migueldejuana Create an index to improve performance loading a loyalty card 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-07-12 13:37migueldejuanaNew Issue
2021-07-12 13:37migueldejuanaAssigned To => migueldejuana
2021-07-12 13:37migueldejuanaTriggers an Emergency Pack => No
2021-07-13 09:33hgbotNote Added: 0130401
2021-07-13 11:23migueldejuanaSummaryFilter by order in Earn + Burn Transactions could freeze the ERP => Filter by order in Earn + Burn Transactions could have bad performance.
2021-07-13 11:23migueldejuanaDescription Updatedbug_revision_view_page.php?rev_id=22874#r22874
2021-07-13 12:45hgbotNote Added: 0130417
2021-07-13 12:45hgbotResolutionopen => fixed
2021-07-13 12:45hgbotStatusnew => closed
2021-07-13 12:45hgbotNote Added: 0130418
2021-07-14 10:40rafarodaTag Attached: NOR
2021-07-14 10:46rafarodaRelationship addedrelated to 0047379
2021-07-22 10:21migueldejuanaStatusclosed => new
2021-07-22 10:21migueldejuanaResolutionfixed => open
2021-07-22 10:22migueldejuanaStatusnew => scheduled
2021-07-22 10:22migueldejuanaStatusscheduled => resolved
2021-07-22 10:22migueldejuanaResolutionopen => fixed
2021-07-22 10:22migueldejuanaReview Assigned To => adrianromero
2021-07-22 10:22migueldejuanaStatusresolved => closed

Notes
(0130401)
hgbot   
2021-07-13 09:33   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/3 [^]
(0130417)
hgbot   
2021-07-13 12:45   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/3 [^]
(0130418)
hgbot   
2021-07-13 12:45   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs [^]
Changeset: d8fcb4d4a3793b32e87089fe09e4f0be4066cffc
Author: Miguel de Juana <miguel.dejuana@openbravo.com>
Date: 2021-07-12T15:46:53+02:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/commit/d8fcb4d4a3793b32e87089fe09e4f0be4066cffc [^]

Fixed ISSUE-0047371: Filter by order in Earn + Burn Transactions could freeze the ERP

- Create an index for c_order_id

---
M src-db/database/model/tables/OBLP_EARNED_POINTS.xml
---