0033657: BP Segmentation: only use the BP by server table in case a BP is used by multiple servers/stores

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0033657

Retail Modules

StoreServer

public

2016-08-08 16:52

2016-08-22 15:32

Reporter

mtaal

Assigned To

AugustoMauch

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

RR16Q4

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

0033657: BP Segmentation: only use the BP by server table in case a BP is used by multiple servers/stores

Description

When a BP belongs to a store and should be replicated to the store then in the current BP segmentation solution a record needs to be present in the BP by Server table.

This means that with 60+M BP records we need as many records in the BP by Server table.

Most BPs will belong to one store at most. Therefore another approach can be to keep track of the first store in a column in the BP itself and only register any additional stores in the BP by store table.

Steps To Reproduce

Install multi-server central+store
Run
Login to webpos
create a BP and add a ticket

Check that a BP by Store record has been created

Proposed Solution

Add a new column to the BP: first-store, FK to ad_org

Set this column when the BP is created for the first time or when the BP is added to a store for the first time

For any subsequent stores follow the current approach to create a record in BP by Server

Rename the current tab and table BP by Server to Additional BPs by Server (or another name which reflects that the table only stores the additional records

Additional Information