If your Django website or app gets a lot of visitors, how do you make your database queries run faster so the app works smoothly?
The first step is to have tooling to measure the speed of your site. The load is not likely to be uniform across all pages.
Sentry or Scout APM are good hosted solutions or Django Debug Toolbar is good to see what’s happening in development.
From there it’s a matter of reducing duplicate or similar queries, adding Indexes to your tables and other techniques to increase the speed of database access.
Even for sites that don’t/won’t get a lot of visitors, I always keep an eye on Django Debug Toolbar when developing locally to look at the queries being made. Really good for highlighting issues and areas for improvements.