Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0047371 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Loyalty Programs for Web POS | major | always | 2021-07-12 13:37 | 2021-07-22 10:22 | |||
| Reporter | migueldejuana | View Status | public | |||||
| Assigned To | migueldejuana | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | adrianromero | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0047371: Filter by order in Earn + Burn Transactions could have bad performance. | |||||||
| Description | In 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 | |||||||
| Tags | NOR | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0130401) hgbot (developer) 2021-07-13 09:33 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/3 [^] |
|
(0130417) hgbot (developer) 2021-07-13 12:45 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.loyalty.programs/-/merge_requests/3 [^] |
|
(0130418) hgbot (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2021-07-12 13:37 | migueldejuana | New Issue | |
| 2021-07-12 13:37 | migueldejuana | Assigned To | => migueldejuana |
| 2021-07-12 13:37 | migueldejuana | Triggers an Emergency Pack | => No |
| 2021-07-13 09:33 | hgbot | Note Added: 0130401 | |
| 2021-07-13 11:23 | migueldejuana | Summary | Filter 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:23 | migueldejuana | Description Updated | View Revisions |
| 2021-07-13 12:45 | hgbot | Note Added: 0130417 | |
| 2021-07-13 12:45 | hgbot | Resolution | open => fixed |
| 2021-07-13 12:45 | hgbot | Status | new => closed |
| 2021-07-13 12:45 | hgbot | Note Added: 0130418 | |
| 2021-07-14 10:40 | rafaroda | Tag Attached: NOR | |
| 2021-07-14 10:46 | rafaroda | Relationship added | related to 0047379 |
| 2021-07-22 10:21 | migueldejuana | Status | closed => new |
| 2021-07-22 10:21 | migueldejuana | Resolution | fixed => open |
| 2021-07-22 10:22 | migueldejuana | Status | new => scheduled |
| 2021-07-22 10:22 | migueldejuana | Status | scheduled => resolved |
| 2021-07-22 10:22 | migueldejuana | Resolution | open => fixed |
| 2021-07-22 10:22 | migueldejuana | Review Assigned To | => adrianromero |
| 2021-07-22 10:22 | migueldejuana | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |