ChristerT_SO Member since 2013 3 posts
Swedish Unemployment Funds
Posted: 4 years ago
Last activity: 3 years 9 months ago

Multiple schemas for customer specific work tables in 7.2.x

We have a system with 20+ different implementation layers / applications and want to separate the different work and history_work tables into different data-schemas for each customer. We have already a split schema database with rules & data separated. Will adding almost 30 different schemas for worktables have any future consequences for e.g., upgrades, performance??  We are today running (in development as demo) with only one implementation layer and this works fine with work & history_work tables in a separate schema. i.e., we have three schemas in the database, 'rules', 'data' as standard for split schema and additionally 'DemoData'. We are presently running Pega 7.2.0 / JBoss 6.4 / Sql Server 2012




Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn