Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036662Retail ModulesWeb POSpublic2017-08-17 14:582017-10-06 12:37
Reportermalsasua 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036662: first search in product tab is very slow
Descriptionin some cases, the first search of product is very slow. The rest of searchs is quick

It happens with all entities, not only for product. And it happens the first time because the database has not been cached yet.
Steps To Reproducein a environment with big volume:
. do login in POS
. delete the Operative System cache to force to read the database files from disk, no from cache:
sudo su -
sync; echo 3 > /proc/sys/vm/drop_caches;
. search a product, in "search" tab -> it takes a long time
. search a product again -> it is very quick
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0040496 new Retail first search of business partner selector is very slow 
Attached Filesdiff issue36662.diff (4,610) 2017-09-04 15:38
https://issues.openbravo.com/file_download.php?file_id=11035&type=bug
diff issue36662-2.diff (1,576) 2017-09-04 15:38
https://issues.openbravo.com/file_download.php?file_id=11036&type=bug
diff issue36662_q1.diff (4,512) 2017-09-11 11:44
https://issues.openbravo.com/file_download.php?file_id=11049&type=bug
diff issue36662-2_q1.diff (1,514) 2017-09-11 11:44
https://issues.openbravo.com/file_download.php?file_id=11050&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-08-17 14:58malsasuaNew Issue
2017-08-17 14:58malsasuaAssigned To => Retail
2017-08-17 14:58malsasuaResolution time => 1504735200
2017-08-17 14:58malsasuaTriggers an Emergency Pack => No
2017-08-28 23:18egoitzIssue Monitored: egoitz
2017-09-04 15:38marvintmFile Added: issue36662.diff
2017-09-04 15:38marvintmFile Added: issue36662-2.diff
2017-09-11 11:44marvintmFile Added: issue36662_q1.diff
2017-09-11 11:44marvintmFile Added: issue36662-2_q1.diff
2017-09-11 13:04jorge-garciaNote Added: 0098939
2017-09-11 13:04jorge-garciaAssigned ToRetail => malsasua
2017-09-11 13:04jorge-garciaStatusnew => feedback
2017-09-25 18:27malsasuaStatusfeedback => new
2017-10-02 13:06malsasuaAssigned Tomalsasua => Retail
2017-10-04 10:12marvintmAssigned ToRetail => marvintm
2017-10-04 10:12hgbotCheckin
2017-10-04 10:12hgbotNote Added: 0099754
2017-10-04 10:12hgbotStatusnew => resolved
2017-10-04 10:12hgbotResolutionopen => fixed
2017-10-04 10:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/1839f70ac77ade8361766dd7cfb6b76bffe00c33 [^]
2017-10-06 12:37migueldejuanaReview Assigned To => migueldejuana
2017-10-06 12:37migueldejuanaNote Added: 0099794
2017-10-06 12:37migueldejuanaStatusresolved => closed
2017-10-06 12:37migueldejuanaFixed in Version => pi
2019-03-29 14:19JONHMRelationship addedrelated to 0040496

Notes
(0098939)
jorge-garcia   
2017-09-11 13:04   
Waiting for confirmation from the customer that everything works as expected
(0099754)
hgbot   
2017-10-04 10:12   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 1839f70ac77ade8361766dd7cfb6b76bffe00c33
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 04 09:56:22 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/1839f70ac77ade8361766dd7cfb6b76bffe00c33 [^]

Fixed issue 36662. Forced precaching of local database models.
Now for every model stored in the local database, a full query will be triggered during login. This seems to be not very expensive in terms of performance, and at the same time seems to force the caching of database files by the operating system, so that subsequent queries are then much faster. The main goal is to prevent the system from initially responding very slowly when the cashier needs to start creating tickets.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M web/org.openbravo.mobile.core/source/data/ob-dal.js
---
(0099794)
migueldejuana   
2017-10-06 12:37   
Tested and reviewed