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