CockroachDB Performance | ORM Chaos

Description

Using an Object Relational Mapper (ORM) can inadvertently generate complex and costly queries, resulting in full table scans or "Cartesian explosions" from many inner joins, which can severely degrade database performance. CockroachDB offers built-in quality of service (QoS) features to mitigate this "ORM chaos" and protect critical production workloads from being adversely affected. Rob Reid shows you how. 00:00: Introduction to ORM risks 01:07: Production workload baseline and monitoring 01:51: Scenario 1: Client evaluation (full table scans) 02:43: Scenario 2: Cartesian explosion (Complex joins) 03:27: Configuring Quality of Service (QoS) and user priorities 04:10: Protecting production by disallowing full table scans 05:07: Admission control and throttling background tasks 06:16: Statement timeouts and concluding best practices 06:32: Summary Learn more at cockroachlabs.com #distributedsql #databases #cockroachdb