Shafqat Farhan Ahmed
I am an experienced full-stack software engineer with 8 years of experience. I specialize in creating scalable web applications with robust backend and frontend features.
My expertise lies in Python Django and React/Next JS, particularly in developing robust applications for the EdTech industry. I have a proven track record of leading teams successfully and delivering projects that exceed client expectations.
I am always eager to mentor junior engineers. I actively contribute to the growth of my team by encouraging a collaborative environment and providing mentorship in Python/Django.
Outside of work, I love exploring mountains and believe in lifelong learning, which shapes my personal and professional growth.
I am dedicated to achieving technical excellence and keeping up with industry advancements, contributing actively to the software engineering field.
Session
In the world of Django development, ensuring optimal performance is paramount for building robust and scalable web applications. Have you ever felt that your Django application is sluggish? You might be facing the infamous N+1 query problem, a notorious performance bottleneck that arises when dealing with ORM-based database queries.
This presentation dives into the world of N+1 queries, explaining how they occur and their impact on performance. We'll explore practical solutions to optimize your code and eliminate these performance bottlenecks.
In this session, we will learn to identify N+1 queries and understand their consequences. We will look into techniques to fix N+1 queries and keep our Django app running smoothly. Additionally, we will take a deeper dive into N+1 queries, exploring advanced optimization strategies like lazy loading, prefetching, and utilizing Django's ORM features like select_related and prefetch_related. Attendees will get a sneak peek into debugging methods, exploring how to use tools like the Django Debug Toolbar and SQL logging to identify and resolve issues.
By the end of this session, you'll be equipped to:
Identify and diagnose N+1 queries in your Django projects.
Implement effective solutions to optimize your application's performance.
Utilize debugging tools and techniques to pinpoint and fix N+1 query issues.
This presentation is suitable for Django developers of all experience levels, as well as for those who might not be working on Django but use other ORM-based frameworks.