1 Results for Popular TechnologySQL

In previous versions of Sitecore Commerce the SQL Database Schema included 2 tables:

CommerceEntities: Stored all Commerce Entities (Catalog Items, Orders, Promotions…) as JSON.-CommerceLists: Maps Entities to Lists (SellableItems To Category for example).

Those tables quickly reached a huge amount of Data and caused significant performance issues in some cases.

To solve that, Sitecore Commerce 9 introduced a simple SQL Sharding technique driven by an Environment JSON Policy-Set: PlugIn.SQL.Sharding.PolicySet-1.0.0.json