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

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajorhave not tried2023-09-19 13:452023-10-31 17:31
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version24Q1
StatusclosedFix 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

0053491: Generation of small keymaps is very slow when there are many products in the masterdata

DescriptionA common use case for clients could be to have many products in the masterdata, but just a few of them as part of the keymap. All products would be scannable an searchable, but only a few of them would be available in the keymap, those that are used more often.

Generating the keymap configuration with those volumes (many products, but very few in keymap) seems to be unnecessarily slow. For instance, the keymap included in pos2 sampledata is taking 0000176:0000040 seconds to be generated.
Steps To Reproduce- Add 100.000 products and configure them to be used in the POS (you can use the attached patch)
- Add some code to measure how long the generation of the keymap takes (see other attached patch)
- Log in. Look for the "Generating the keymap took" message, note that it takes very long.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
causes defect 0054361 closedAugustoMauch Keymap- Unable to do login if product is not in the Assorment and the price list of a store 

-  Notes
hgbot (developer)
2023-09-19 14:48

Merge Request created: [^]
hgbot (developer)
2023-10-31 17:31

Merge request merged: [^]
hgbot (developer)
2023-10-31 17:31

Directly closing issue as related merge request is already approved.

Repository: [^]
Changeset: afeb827459f6f1d4ac07e8d35e9b6ec4e9313b5b
Author: Augusto Mauch <>
Date: 31-10-2023 16:31:42
URL: [^]

Fixes ISSUE-53491: Updates two criterias to improve performance of keymap generation

There were two criterias that, the way they were being built, resulted in very slow executions, that went over all the product
records one by one, the criteria then being executed in-memory for all those records.

The updated criterias take advantage of the existing indexes, and only do the in-memory filter after having already extracted
the relevant records using an index of the model.

M web-jspack/org.openbravo.pos2/src/components/KeyMapEditor/steps/KeyMapEditorKeymapsGrid/__test__/KeyMapEditorKeymapsGrid.test.jsx
M web-jspack/org.openbravo.pos2/src/configurations/keymapConfiguration/__test__/getKeymapInformation.test.js
M web-jspack/org.openbravo.pos2/src/configurations/keymapConfiguration/loadKeymapConfigurations.js
M web-jspack/org.openbravo.pos2/src/configurations/keymapConfiguration/utils/getAssortmentProducts.js

- Issue History
Date Modified Username Field Change
2023-09-19 13:45 AugustoMauch New Issue
2023-09-19 13:45 AugustoMauch Assigned To => Retail
2023-09-19 13:45 AugustoMauch Triggers an Emergency Pack => No
2023-09-19 13:45 AugustoMauch Assigned To Retail => AugustoMauch
2023-09-19 13:45 AugustoMauch Status new => scheduled
2023-09-19 14:48 hgbot Note Added: 0154994
2023-10-31 17:31 hgbot Note Added: 0156574
2023-10-31 17:31 hgbot Resolution open => fixed
2023-10-31 17:31 hgbot Status scheduled => closed
2023-10-31 17:31 hgbot Fixed in Version => 24Q1
2023-10-31 17:31 hgbot Note Added: 0156575
2024-01-16 14:24 AugustoMauch Relationship added causes 0054022
2024-01-16 14:44 AugustoMauch Relationship deleted causes 0054022
2024-01-16 14:44 AugustoMauch Relationship added causes 0054361

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker