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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0047379
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Loyalty Programs for Web POSminoralways2021-07-13 09:122021-07-22 10:23
ReportermigueldejuanaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toadrianromero
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047379: 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
TagsNOR
Attached Files

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

-  Notes
(0130400)
hgbot (developer)
2021-07-13 09:32

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/2 [^]
(0130420)
hgbot (developer)
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 (developer)
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 (developer)
2021-07-13 16:31

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/2 [^]

- Issue History
Date Modified Username Field Change
2021-07-13 09:12 migueldejuana New Issue
2021-07-13 09:12 migueldejuana Assigned To => migueldejuana
2021-07-13 09:12 migueldejuana Triggers an Emergency Pack => No
2021-07-13 09:32 hgbot Note Added: 0130400
2021-07-13 16:31 hgbot Resolution open => fixed
2021-07-13 16:31 hgbot Status new => closed
2021-07-13 16:31 hgbot Note Added: 0130420
2021-07-13 16:31 hgbot Note Added: 0130421
2021-07-13 16:31 hgbot Note Added: 0130422
2021-07-14 10:45 rafaroda Tag Attached: NOR
2021-07-14 10:46 rafaroda Relationship added related to 0047371
2021-07-22 10:22 migueldejuana Status closed => new
2021-07-22 10:22 migueldejuana Resolution fixed => open
2021-07-22 10:23 migueldejuana Status new => scheduled
2021-07-22 10:23 migueldejuana Status scheduled => resolved
2021-07-22 10:23 migueldejuana Resolution open => fixed
2021-07-22 10:23 migueldejuana Review Assigned To => adrianromero
2021-07-22 10:23 migueldejuana Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker