#query-optimization - Danny's blog

Skip to main content

Hashnode Danny's blog

Command Palette

Search for a command to run...

#query-optimization

Articles tagged with #query-optimization

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...
Nov 17, 20251 min read11
`LIKE` uses a range index
A Django's Auth table's indexes: mysql> show index from auth_user; +-----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_un...
May 21, 20243 min read20

© 2026 Danny's blog

Archive
Recommendations
Privacy
Terms