0034672: Default page size (35000) of initial data load is too high for high volume cases

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0034672

Retail Modules

Web POS

public

2016-12-02 09:05

2016-12-23 14:26

Reporter

mtaal

Assigned To

Retail

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

RR17Q1

Fixed in Version

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0034672: Default page size (35000) of initial data load is too high for high volume cases

Description

The default page size to load data from the backend is 35000 [1]. When there are many products or BPs this will load a big batch to the client to be inserted there. This insert takes a long time and requires lots of memory from the browser.

With 70000+ products load times were 15 mins or so.

The attached patch has been working correctly at a customer (hipertextil) for many months.

[1]
https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/file/7f3a3dde78ff/web/org.openbravo.mobile.core/source/data/ob-datasource.js#l495 [^]

Steps To Reproduce

Create a large set of products (70000) and put in assortment
clean cache
login to webpos
see that products get loaded in batches of 35000

Proposed Solution

See attached dif

It makes sense to backport this issue to previous releases Q3 and further.

Additional Information

Tags

No tags attached.

Relationships

duplicate of

defect

0034669

RR17Q1