Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Retail Modules] Web POSmajorN/A2019-06-10 17:042020-04-14 15:09
ReporterALopeteguiView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0041063: Search of document Number has bad performance because the prefix is repeated in the number

DescriptioniContains 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 ReproduceMore 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 SolutionWe 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker