#query-optimization

Articles tagged with #query-optimization

Nov 17, 2025
Nov 17, 20251 min read11 views
1+N querys
Widely know as N+plus one problem, it’s actually a misnomer. As @adamj.eu’s article neatly summarize with examples (and now my dyslexic mind actually understands it), it’s one query to get a list of N objects that you iterate over. And each iteration...
1 min read11 views
May 21, 2024
May 21, 20243 min read20 views
`LIKE` uses a range index
A Django's Auth table's indexes: mysql> show index from auth_user; +-----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_un...
3 min read20 views

#query-optimization - Danny's blog