I switched a table to Guid.CreateVersion7() keys for the time-ordering, then benchmarked whether they actually come out sorted. In a tight loop they do not, and here is why.
In DynamoDB, a single-table design stores one-to-many relationships in a single physical block while still following relational-like normal form decomposition.…