Improving Performance of Growing Django Apps

How to improve the performance of your app before you face the need to upgrade your hardware.

Transcript

1. Improving Performance of Growing Django Apps Williams Méndez github.com/wm3ndez/pycaribbean-2018 @wmendezt //codemera
2. Common areas of improvement • Database ◦ Slow queries ◦ Too many queries • Slow python code • Cache ◦ Views, Templates ◦ Functions • Templates ◦ Render-blocking assets ◦ Template Tags • Async Tasks ◦ Email ◦ Refresh cache ◦ Others
3. Common improvements points • Database ◦ Slow queries ◦ Too many queries • Slow python code • Cache ◦ Views, Templates ◦ Functions • Templates ◦ Render-blocking assets ◦ Template Tags • Async Tasks ◦ Email ◦ Cache ◦ Others
4. Tools • Your Browser Developer Tools • Django Debug Toolbar • Django Silk • cProfile (Python built-in profiler)
5. Tools • Your Browser Developer Tools • Django Debug Toolbar • Django Silk • cProfile (Python built-in profiler)
6. Blog Models
7. Blog Models
8. The Blog...
9. Django Debug Toolbar
10. Views
11. Templates
12. Templates
13. Duplicated queries
14. Select_related & prefetch_related
15. Less queries
16. blog.blog2.models
17. Before indexing
18. After indexing
19. Cache, queues & sessions with Redis
20. Authors page
21. Cache View
22. Template Fragment Caching
23. Caching function results
24. Caching function results
25. Blog 1 vs Blog 3
26. Django-Silk
27. Django RQ
28. Django RQ
29. Other suggestions • Raw Queries • Invest some time in learning your DB Engine • Database Tuning • Take care of your Middlewares • Use a custom Auth Model(User) • React/Angular/Vue.js
30. THANK YOU!