How to find bottlenecks in Django which have a high impact on the application performance. Originally published at https://avilpage.com/2018/12/django-bottleneck-performance-scaling.html Introduction When optimizing the performance of web application, a common mistake is to start with optimizing the slowest page(or API). In addition to considering response time, we should also consider the traffic it is receiving to prioritize the order of optimization. In this article, we will profile a Django web app, find high-impact performance bottlenecks and then start optimizing them to yield better performance. Profiling is an open source profiling tool which intercepts and stores HTTP requests data. Install it with pip. django-silk pip install django-silk Add to installed apps and include silk middleware in django settings. silk MIDDLEWARE = [...'silk.middleware.SilkyMiddleware',...] INSTALLED_APPS = (...'silk') Run migrations so that Silk can create required database tables to store profile data. $ python manage.py makemigrations$ python manage.py migrate$ python manage.py collectstatic Include silk urls in root urlconf to view the profile data. urlpatterns += [url(r'^silk/', include('silk.urls', namespace='silk'))] On silk requests page( ), we can see all requests and sort them by overall time or time spent in the database. http://localhost:8000/silk/requests/ High Impact Bottlenecks Silk creates table which contains information about the requests processed by Django. silk_request $ pgcli library> \d silk_request; +--------------------+--------------------------+-------------+| Column | Type | Modifiers ||--------------------+--------------------------+-------------|| id | character varying(36) | not null || path | character varying(190) | not null || time_taken | double precision | not null |... We can group these requests data by , calculate the number of requests, average time taken and impact factor of each path. Since we are considering response time and traffic, impact factor will be the product of average response time and number of requests for that path. path library> SELECTs.*, round((s.avg_time * s.count)/max(s.avg_time*s.count) over ()::NUMERIC,2) as impactFROM(select path, round(avg(time_taken)::numeric,2) as avg_time, count(path) as count from silk_request group by PATH)sORDER BY impact DESC; +-------------------------+------------+---------+----------+| path | avg_time | count | impact ||-------------------------+------------+---------+----------|| /point/book/book/ | 239.90 | 1400 | 1.00 || /point/book/data/ | 94.81 | 1900 | 0.54 || /point/ | 152.49 | 900 | 0.41 || /point/login/ | 307.03 | 400 | 0.37 || / | 106.51 | 1000 | 0.32 || /point/auth/user/ | 494.11 | 200 | 0.29 |... We can see has the highest impact even though it is neither most visited nor slowest view. Optimizing this view first yields in overall better performance of web app. /point/book/book/ Conclusion In this article, we learned how to profile the Django web app and identify bottlenecks to improve performance. In the next article, we will learn how to optimize these bottlenecks by taking an in-depth look at them. More tips and tricks about Django are available at https://avilpage.com/tags/django-tips-tricks.html
