Efficient Django QuerySet Use
Jayson Falkner gave a talk at a recent Django Meetup in San Francisco on the advanced use of Django’s QuerySet API based on lessons learned at Counsyl.
Below are the slides and audio.
[slideshare id=27113252&doc=efficient-django-queryset-use-131011172930-phpapp01]
You’ll learn how to debug, optimize and use the QuerySet API efficiently. The main examples focus on demystifying how QuerySet maps to SQL and how seemingly simple Python code, presumably fast O(1) queries, can result in unacceptably long runtime and often O(N) or worse queries. Solutions are provided for keeping your Python code simple and RDMS use performant.
Jayson’s code can be found on GitHub.

Jayson Falker is a software developer for Counsyl. He has an EEN/CS degree and a PhD in Bioinformatics. He is a long-time open-source Linux/Java/Web developer, book author, and presenter. He has focused on proteomics and genomics research since the mid-2000’s, including working for a few years at startups and for Dow AgroSciences. Jayson is quick to get his geek on and also loves to build ridiculous side-projects, including a 6′ tall Jenga set that weighs 300lbs and mobile apps that give you awesome virtual mustaches.
Recent posts
March 17, 2021
NAVIGATING YOUR BREAST AND OVARIAN HEALTH IN THE (NEVER-ENDING) ERA OF COVID
It has been almost a year since most of us found ourselves in the completely unchartered territory of “sheltering in…
Read more about NAVIGATING YOUR BREAST AND OVARIAN HEALTH IN THE (NEVER-ENDING) ERA OF COVIDFebruary 25, 2021
I Am Glad to Know: The Importance of Carrier Screening Through the Voice of a Carrier
This Sunday, February 28th, is #RareDiseaseDay! To raise awareness and support for the rare disease community, Myriad Women’s Health partnered…
Read more about I Am Glad to Know: The Importance of Carrier Screening Through the Voice of a CarrierDecember 23, 2020
Myriad’s 7 Greatest Hits in 2020
Before we say goodbye to 2020, we’d like to thank and recognize our partners. Together, we ensure patients have access…
Read more about Myriad’s 7 Greatest Hits in 2020