CockroachDB Performance | ORM Chaos

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

Видео CockroachDB Performance | ORM Chaos канала CockroachDB