Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047379Retail ModulesLoyalty Programs for Web POSpublic2021-07-13 09:122021-07-22 10:23
Reportermigueldejuana 
Assigned Tomigueldejuana 
PrioritynormalSeverityminorReproducibilityalways
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
Summary0047379: Create an index to improve performance loading a loyalty card
DescriptionLoading a Loyalty Card using the cardNumber to filter, the performance is not good when there are a lot of loyalty cards.
Steps To Reproducen/a
Proposed SolutionCreate an index in oblp_card for cardnumber
Additional Information
TagsNOR
Relationships
related to defect 0047371 closed migueldejuana Filter by order in Earn + Burn Transactions could have bad performance. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-07-13 09:12migueldejuanaNew Issue
2021-07-13 09:12migueldejuanaAssigned To => migueldejuana
2021-07-13 09:12migueldejuanaTriggers an Emergency Pack => No
2021-07-13 09:32hgbotNote Added: 0130400
2021-07-13 16:31hgbotResolutionopen => fixed
2021-07-13 16:31hgbotStatusnew => closed
2021-07-13 16:31hgbotNote Added: 0130420
2021-07-13 16:31hgbotNote Added: 0130421
2021-07-13 16:31hgbotNote Added: 0130422
2021-07-14 10:45rafarodaTag Attached: NOR
2021-07-14 10:46rafarodaRelationship addedrelated to 0047371
2021-07-22 10:22migueldejuanaStatusclosed => new
2021-07-22 10:22migueldejuanaResolutionfixed => open
2021-07-22 10:23migueldejuanaStatusnew => scheduled
2021-07-22 10:23migueldejuanaStatusscheduled => resolved
2021-07-22 10:23migueldejuanaResolutionopen => fixed
2021-07-22 10:23migueldejuanaReview Assigned To => adrianromero
2021-07-22 10:23migueldejuanaStatusresolved => closed

Notes
(0130400)
hgbot   
2021-07-13 09:32   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/2 [^]
(0130420)
hgbot   
2021-07-13 16:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs [^]
Changeset: 9f116f1e3f16f6c55352d881799bea94e3be5508
Author: Miguel de Juana <miguel.dejuana@openbravo.com>
Date: 2021-07-13T12:35:38+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/commit/9f116f1e3f16f6c55352d881799bea94e3be5508 [^]

Fixes ISSUE-0047379: Create an index to improve performance loading a loyalty card

- Add Upper index

---
M src-db/database/model/tables/OBLP_CARD.xml
---
(0130421)
hgbot   
2021-07-13 16:31   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs [^]
Changeset: 1589d0468e02a6f34675fbfb82828c47c167f290
Author: Miguel de Juana <miguel.dejuana@openbravo.com>
Date: 2021-07-13T12:35:38+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/commit/1589d0468e02a6f34675fbfb82828c47c167f290 [^]

Related ISSUE-0047379: Create an index to improve performance loading a loyalty card

- Remove contains in the index because the loyalty card query does not
use contains

---
M src-db/database/model/tables/OBLP_CARD.xml
---
(0130422)
hgbot   
2021-07-13 16:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/2 [^]