News for hackers. Stuff that matters.
Re:12 requests per second: A realistic look at Python web fr... by DangitBobby on Thursday February 18, 2021 @11:44PM (#26189862)
My guess is accessing a related field within a loop causing a database request per iteration, e.g.

``` [book.author.name for book in Book.objects.all()] ```

Re:12 requests per second: A realistic look at Python web fr... by acdha on Friday February 19, 2021 @12:14AM (#26190016)
That’d be my guess: prefetch_related is great but you need to guard it with something like an assertNumQueries test to avoid accidental regressions.
Re:12 requests per second: A realistic look at Python web fr... by rglullis on Friday February 19, 2021 @06:56AM (#26192155)
Maybe I spent too much time with Django already, but if I see anyone doing anything but Book.objects.values_list('author__name', flat=True) for this type of expression, I would mark it as a 3x WTF? in the code review.
Re:12 requests per second: A realistic look at Python web fr... by DangitBobby on Friday February 19, 2021 @05:55PM (#26199129)
As written, it's obvious you should be doing something else like `values()` or `values_list()`. You're much more likely to fall victim to this anti-pattern if it's done within a standard for-loop that has a bunch of other stuff going on. I just wrote it as a list comprehension to avoid having to muck about with formatting on my phone.
Re:12 requests per second: A realistic look at Python web fr... by acdha on Friday February 19, 2021 @09:24AM (#26193449)
I’d also allow prefetch_related if you’re using more than the most trivial data - no point in duplicating logic you have in your models if you have a method which generates something like a name, URL, etc. based on multiple fields.
Re:12 requests per second: A realistic look at Python web fr... by ZephyrBlu on Friday February 19, 2021 @12:20AM (#26190049)
Funnily enough, I recently optimized some code along these lines.

The way I sped it up was to call `.values()` on the query, which serializes the data into a dict and prevented me from accidentally making subsueqent calls.

PS: Indent by 4 spaces for code formatting.

Re:12 requests per second: A realistic look at Python web fr... by monkpit on Friday February 19, 2021 @12:25AM (#26190073)
s/ident/indent/
Re:12 requests per second: A realistic look at Python web fr... by ZephyrBlu on Friday February 19, 2021 @05:51AM (#26191691)
Thanks :).