0040496: first search of business partner selector is very slow

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0040496

Retail Modules

Web POS

public

2019-03-29 14:18

2019-04-24 09:59

Reporter

JONHM

Assigned To

Retail

Priority

high

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0040496: first search of business partner selector is very slow

Description

In some cases, the first search of business partner selector is very slow. The rest of searches are quick.

Patch from issue 0036662 already applied but the issue persists.

It happens the first time because the database has not been cached yet. It's a problem when the customer shut down the terminal every night.

Steps To Reproduce

in 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 (in local terminal):
sudo su -
sync; echo 3 > /proc/sys/vm/drop_caches;
. search for an specific BP, in BP selector -> it takes a long time (about 150 sec)
. search the BP again -> it is very quick

Proposed Solution

Additional Information