Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041225Retail ModulesWeb POSpublic2019-07-02 12:322019-09-19 16:38
Reporterfrancisco 
Assigned Togorka_gil 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product VersionRR18Q3.4 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041225: Taking too long to load master.products when full refresh
DescriptionAfter a full refresh is taking to load.
The most timing consume to request is /openbravo/org.openbravo.mobile.core.service.jsonrest/org.openbravo.retail.posterminal.master.Product/ that it takes around 12sec

please see screenshots with the timing

Client has 8548 products
Steps To ReproduceContact with fanfi for test environment access:

Load with a full refresh
check the with the dev tools timing request.



NOTE ADDED: THAT HAPPENS USING BEST SELLERS MODULE
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Selection_614.png (206,590) 2019-07-02 12:32
https://issues.openbravo.com/file_download.php?file_id=13076&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2019-07-02 12:32franciscoNew Issue
2019-07-02 12:32franciscoAssigned To => Retail
2019-07-02 12:32franciscoFile Added: Selection_614.png
2019-07-02 12:32franciscoResolution time => 1563832800
2019-07-02 12:32franciscoTriggers an Emergency Pack => No
2019-07-02 12:40rafarodaIssue Monitored: rafaroda
2019-07-02 12:50franciscoDescription Updatedbug_revision_view_page.php?rev_id=19023#r19023
2019-07-02 12:50franciscoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19025#r19025
2019-07-25 12:10egoitzSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19198#r19198
2019-08-09 12:53marvintmResolution time1563832800 => 1566684000
2019-08-21 10:46ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-08-22 15:24ranjith_qualiantech_comStatusnew => scheduled
2019-09-19 15:01gorka_gilAssigned Toranjith_qualiantech_com => gorka_gil
2019-09-19 16:37marvintmReview Assigned To => marvintm
2019-09-19 16:37marvintmNote Added: 0114669
2019-09-19 16:37marvintmStatusscheduled => closed
2019-09-19 16:37marvintmResolutionopen => no change required

Notes
(0114669)
marvintm   
2019-09-19 16:37   
The product is working as intended. The slowness doesn't come from the query, it comes from having to download a large amount of data. The product data cannot be compressed, as the system was configured to load the product images as part of the product information, and together with this, there is a small amount of very large product images which should be reduced.