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.


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 Falkner, software engineer at Counsyl
Jayson Falkner, software engineer at Counsyl

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.

Author: Counsyl

Counsyl provides DNA testing and genetic counseling services. We're committed to helping patients understand their DNA and how it can inform important health decisions. Whether it’s starting a family or evaluating risk for cancer, Counsyl's DNA tests provide patients with early awareness about genetic conditions, so they can live informed and prepare for the future. Counsyl has screened more than 750,000 patients and served more than 10,000 healthcare professionals. For more information, visit www.counsyl.com.

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s