Query Routing

Due to the large scale that kdb+ systems commonly grow to, it is important to build solid foundations so that as the number of clients running queries and size of databases increase, the system is able to easily absorb the extra capacity. 

Traditional load-balancing techniques such as a straightforward round-robin approach to resource allocation is an acceptable approach for many systems, however it can result in several queries becoming queued up behind a long-running query whilst other service resources are idle. 

Here we will look at kdb+’s approach to query routing and how it handles data querying at scale. 

The PowerPoint deck used in the video can be found under the Materials tab at the top of the page.