Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0041063 | Retail Modules | Web POS | public | 2019-06-10 17:04 | 2022-03-03 14:14 |
| Reporter | ALopetegui | ||||
| Assigned To | Retail | ||||
| Priority | normal | Severity | major | Reproducibility | N/A |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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 | 0041063: Search of document Number has bad performance because the prefix is repeated in the number | ||||
| Description | iContains Searches of the document Number in webPos has bad performance on high volume environments Above all if you search with the whole document number or with the prefix, because the GIN trigram index searches by group of three consecutive characters taken from a string and the document Number includes the terminal number and "0"s to complete it, therefore the prefix is very common. | ||||
| Steps To Reproduce | More than 1 million of orders, Same terminal prefix in the Document Number. "0"s in the prefix to complete the documentNo with the same number of characters. Compare results searching by 1- Complete number 2- First half numbers 3- Last half numbers 1 and 2 searches will be worse than 3. | ||||
| Proposed Solution | We exposed the problem to 2nd quadrant and they told us that they see a design defect in the the document number, because there are 2 things to improve: 1- Terminal Number prefix: This number should be in an other column, not included as prefix in the documentNo. 2- several '0' to complete the document Number: This also makes a part of number very repetitive, creating more posibilites to trigram search in "000". This prefix should be removed. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2019-06-10 17:04 | ALopetegui | New Issue | |||
| 2019-06-10 17:04 | ALopetegui | Assigned To | => adrianromero | ||
| 2020-04-14 15:09 | marvintm | Project | Java Client POS => Retail Modules | ||
| 2020-04-14 15:09 | marvintm | Triggers an Emergency Pack | => No | ||
| 2020-04-14 15:09 | marvintm | Category | 01 - General => Web POS | ||
| 2022-03-03 14:14 | adrianromero | Assigned To | adrianromero => Retail | ||
| There are no notes attached to this issue. |