Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0041063 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Retail Modules] Web POS | major | N/A | 2019-06-10 17:04 | 2022-03-03 14:14 | |||||||
| Reporter | ALopetegui | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | 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 | ||||||||||||
| 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |