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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

feature request

0032252

RR16Q4

closed

AugustoMauch

Store Server Data Segmentation and Sync for BP

Notes
(0089283) AugustoMauch (manager) 2016-08-22 15:32	This flow has been handled in this issue [1] [1] https://issues.openbravo.com/view.php?id=32252 [^]

Issue History
Date Modified	Username	Field	Change
2016-08-08 16:52	mtaal	New Issue
2016-08-08 16:52	mtaal	Assigned To	=> AugustoMauch
2016-08-08 16:52	mtaal	Triggers an Emergency Pack	=> No
2016-08-08 16:53	shuehner	Issue Monitored: shuehner
2016-08-22 15:32	AugustoMauch	Relationship added	duplicate of 0032252
2016-08-22 15:32	AugustoMauch	Note Added: 0089283
2016-08-22 15:32	AugustoMauch	Status	new => closed
2016-08-22 15:32	AugustoMauch	Resolution	open => duplicate