Coding Blocks cover image

Designing Data-Intensive Applications – Secondary Indexes, Rebalancing, Routing

Coding Blocks

00:00

Query Base Partitioning

If you were going to retain 90 days rth of data, and you wanted to drop the partition for the day, and you didn't use the document base partitioning an you'd have to go back to that global partition a. O case, we've got these local indexes on the partition. And so if our user only has a, you know, 20 transactions over seven years, and those 20 transactions only happen on 11 different partitions, than we only need to go query 11 partitions. So that's a lot less stress on the system. Its a whole lotless network traffic. Ah, it's going to be faster because we don't have to wait on whatever is the slowest

Play episode from 46:34
Transcript

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app