Django Time-Based Lookups: A Performance Trap
The article shows how certain Django time-based field lookups can bypass database indexes and turn a simple filter into a full table scan, dramatically slowing queries. It then demonstrates a much faster pattern by computing time boundaries in Python so the database can use the existing index and drop execution time from tens of seconds to under a second.
https://johnnymetz.com/posts/django-time-based-lookups-performance/
The article shows how certain Django time-based field lookups can bypass database indexes and turn a simple filter into a full table scan, dramatically slowing queries. It then demonstrates a much faster pattern by computing time boundaries in Python so the database can use the existing index and drop execution time from tens of seconds to under a second.
https://johnnymetz.com/posts/django-time-based-lookups-performance/
Johnny Metz
Django Time-Based Lookups: A Performance Trap
Django’s field lookups are one of the ORM’s best features, but time-based lookups can quietly bypass database indexes, turning fast queries into expensive full table scans.
A Slow Production Query
I ran into this while debugging a 30 second query on a large…
A Slow Production Query
I ran into this while debugging a 30 second query on a large…
MimicKit
A lightweight suite of motion imitation methods for training controllers.
https://github.com/xbpeng/MimicKit
A lightweight suite of motion imitation methods for training controllers.
https://github.com/xbpeng/MimicKit
GitHub
GitHub - xbpeng/MimicKit: A lightweight suite of motion imitation methods for training controllers.
A lightweight suite of motion imitation methods for training controllers. - xbpeng/MimicKit