This will better distribute the load. Today, since we only use warehouse_id as the hash, all data for a warehouse hits a single shard creating a hotspot.
Note that all queries always provide warehouse_id and district_id. So, this is a safe change to make.
This will better distribute the load. Today, since we only use warehouse_id as the hash, all data for a warehouse hits a single shard creating a hotspot. Note that all queries always provide warehouse_id and district_id. So, this is a safe change to make.