152: The Future Database with Sam Lambert
Programming Throwdown
00:00
Using a Sharding Scheme in a Database?
If it's not done in a healthy way, then every query is going to need to read from every shard. Often we have to help users design a sharding scheme that works for their queries. It's much better off if you locate data. Another thing that the test does extremely well is to allows you to materialize a table elsewhere. So what that means is imagine you've got this beautiful sharding scheme. 99% of queries, just amazing. They go to the local shard. This is one query. Again, the building of that, that is some really hard tech. That has been used by billions of users around the world as these large companies use for tests.
Transcript
Play full episode
