Improve DB Performance with "select_related" in Django
#python #django #coding #programming #buildinpublic

Optimizing Django Queries and Improving Performance #Django #Queries #Optimization #Performance #Queryset #Database #Select_related #Prefetch_related #Indexing #Caching #Annotations #Debug

Quick Django tip 💡

Use select_related() or prefetch_related() to reduce DB queries.

Your page load time will thank you.

#WebDev #DjangoTips

It's kind of embarrassing when you add ORM optimizations like select_related, prefetch_related, only, or defer expecting better performance, but some queries actually get slower instead.

Async Django websites are probably much faster just because it forces you to use select_related()

Vou marcar com alguma branch antes de remover e vou remover (na vdd já removi o código todo kkkk só estou garantindo os select_related, prefetch_related e afins, depois vou fazer um teste genérico se tá tudo ok e foi)

Eu olhei de novo ali agora, caiu de 598 queries pra 11 (tô com os dois endpoints funcionais ainda) kkkkkk

Teve um pequeno problema que foi culpa de uma modelagem de dados cagada que corrigimos agora, o resto esqueceram de usar select_related e prefetch_related do django pra trazer os dados

🛠️ Django Devs! If you're not using Django Debug Toolbar, you're missing out!

⚡ See all SQL queries
⚡ Monitor performance bottlenecks
⚡ Reduce excessive DB calls with select_related() & prefetch_related()

Stop the N+1 query problem before it kills your app’s speed! 🚀 #Django #WebDev #TechWithTwin