OLAP or OLTP? Optimize for Both with Workload Prioritization
OLTP and Analytics are very different. One is characterized by many concurrent small requests, with a high sensitivity to latency, while the other typically processes large streams of data with more emphasis on throughput. The talk will cover: - the different requirements of the two workloads - how ScyllaDB optimizes for both - performance isolation of different workloads within ScyllaDB - how ScyllaDB supports concurrent OLTP and Analytics without sacrificing either latency or throughput - measurements