Projects:Retail Login Process Improvements

Contents 1 Introduction 2 Status 3 Documentation 4 QA

Introduction

The WebPOS login implementation can be improved from a performance/resource usage point of view.

There are several areas which can be addressed:

• the number of requests done when logging in can be decreased by combining requests together.
• re-visit the queries done when logging in, prevent duplicate queries or change query structure to make use of indexes or add new indexes.

Tracking issue:

• Tracking issue: https://issues.openbravo.com/view.php?id=29911

Status

With the current product version (15Q4) and enabling remote data preferences it was possible to achieve 900 concurrent logins within a few minutes. This achieves our goals to improve the login speed.

See the above issue for other details of the status.

Documentation

As this is mainly a deeper technical change which is focused on specific areas there is no need for separate documentation. The above issue and its changesets will show the needed changes.

QA

Concurrent logins were tested using jmeter, the results are outlined in the following 2 docs:

• https://docs.google.com/spreadsheets/d/1VTVsTeQn3d4Mb11TnfZLhexMYsPT-wNTX9ukypbWN1I/edit#gid=2002035676
• https://docs.google.com/document/d/15KyTV2thUk4oVFcQSaqsfJv6THbMzyUW9yU7hCEVGNk/edit

From a QA perspective there are enough automated test cases already which test the login and master data loading process. No separate automated test is needed.