|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|feature request||[Retail Modules] Web POS||major||N/A||2019-06-10 17:04||2020-04-14 15:09|
|Priority||normal||Resolution||open||Fixed in Version|
|Status||new||Fix in branch||Fixed in SCM revision|
|OS Version||Database version||Ant version|
|Product Version||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
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.|
|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|
|Copyright © 2000 - 2009 MantisBT Group|