Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0046074
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Retail Modules] Web POSmajoralways2021-03-15 14:032021-05-03 13:28
ReporterjetxarriView Statuspublic 
Assigned ToRetail 
PriorityurgentResolutionopenFixed 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
Summary

0046074: Models with multiple queries do not accept pagination by Id

DescriptionWeb POS models like BP, Product or BPLoc can not be load using the pagination by id and instead they are being paginated using the offset.

Using the offset is creating a performance problem in the server when more than 400 full master data refreshes are executed at the same time. The main problem of using offset, it is creating a massive reading of the disk.
Steps To Reproduce-Configure a batch of 100 using preference "Masterdata models batch size". You need to have more than 100 products, however configure a lower number
-Do the login in Web POS
-Verify that the pagination is done using offset
TagsNOR, Performance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0046077 closedrqueralta Double upper case in the where clause searching by Name, search key or UPC 
related to feature request 0046183 newRetail Hierarchy of Price Lists: development to reduce number of records M_PRODUCTPRICE 
related to feature request 0046182 newRetail Refactor/improve of Promo Engine and full / incremental refresh to remove the ProductCharacteristicsValue model 
related to defect 0046187 closedranjith_qualiantech_com WebPOS triggered unexpected Full Refresh 

-  Notes
(0126766)
marvintm (developer)
2021-03-18 07:59

I've moved this topic to feature request. This change would be useful, but it is not really a defect but a new project that would need to be developed, to add a feature that would allow us to enable pagination by id in masterdata models that are composed of more than one query.
(0127741)
jetxarri (developer)
2021-05-03 13:28

Merge requests were created

https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/378 [^]

https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/208 [^]

- Issue History
Date Modified Username Field Change
2021-03-15 14:03 jetxarri New Issue
2021-03-15 14:03 jetxarri Assigned To => Retail
2021-03-15 14:03 jetxarri Triggers an Emergency Pack => No
2021-03-15 16:25 rafaroda Tag Attached: NOR
2021-03-15 16:26 rafaroda Priority high => urgent
2021-03-15 17:31 rafaroda Relationship added related to 0046077
2021-03-18 07:59 marvintm Note Added: 0126766
2021-03-18 07:59 marvintm Type defect => feature request
2021-03-30 14:07 rafaroda Relationship added related to 0046183
2021-03-30 14:10 rafaroda Relationship added related to 0046182
2021-03-30 16:53 rafaroda Relationship added related to 0046187
2021-04-14 13:12 rafaroda Tag Attached: Performance
2021-05-03 13:28 jetxarri Note Added: 0127741


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker