Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0049681 | Retail Modules | Web POS | public | 2022-06-29 13:52 | 2022-08-30 12:30 |
|
| Reporter | malsasua | |
| Assigned To | ranjith_qualiantech_com | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR22Q4 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0049681: With big volumes the Verify Return selector is very slow when no filter is used |
| Description | In a customer with a big volume of data, if Verify Return selector is used without any filter (Document Number filter is empty), the query is taking for more than 1 min.
The Verify Return search is returning only 301 records ordered by updated date, but the query is taking count all records |
| Steps To Reproduce | . in customer with a big volume of data
. open Verify Return selector
. click in search button
> 1min later: 301 records are returned ordered by updated |
| Proposed Solution | . if no filter is used, we should include one filter by the last X days.
it has no sense, without filters, search in receipts for more than several months or years, and return only the 301 newer records. |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0049683 | | closed | ranjith_qualiantech_com | With big volumes the Verify Return selector is very slow using "contains" operator in document number |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2022-06-29 13:52 | malsasua | New Issue | |
| 2022-06-29 13:52 | malsasua | Assigned To | => Retail |
| 2022-06-29 13:52 | malsasua | Triggers an Emergency Pack | => No |
| 2022-06-29 14:16 | malsasua | Tag Attached: Performance | |
| 2022-06-29 14:22 | malsasua | Relationship added | related to 0049683 |
| 2022-07-05 07:39 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2022-07-05 07:39 | ranjith_qualiantech_com | Status | new => scheduled |
| 2022-07-08 14:22 | hector_hernaez | Issue Monitored: hector_hernaez | |
| 2022-07-12 07:16 | hgbot | Note Added: 0139258 | |
| 2022-07-25 09:21 | hgbot | Resolution | open => fixed |
| 2022-07-25 09:21 | hgbot | Status | scheduled => closed |
| 2022-07-25 09:22 | hgbot | Fixed in Version | => RR22Q4 |
| 2022-07-25 09:22 | hgbot | Note Added: 0139576 | |
| 2022-07-25 09:22 | hgbot | Note Added: 0139577 | |
| 2022-08-30 12:30 | hgbot | Note Added: 0140501 | |