[PATCH] Optimise querying of checks in patch list view

Johannes Berg johannes at sipsolutions.net
Thu Sep 15 18:50:56 AEST 2016


On Thu, 2016-09-15 at 18:10 +1000, Daniel Axtens wrote:
> tl;dr: with about 300 mails from the patchwork list, according to
> django-debug-toolbar, to render
> http://localhost:8000/project/patchwork/list/
> 
> Without this patch:
>  - ~1.35 seconds of CPU time
>  - 110 SQL queries, taking ~70ms
> 
> With this patch:
>  - < 0.3 seconds of CPU time
>  - 10 SQL queries, taking <20ms
> 
Hmm. I wonder if this has an impact on my todo-list issue as well?

Perhaps you have an easy way to check that? I don't actually have a
local setup right now :(

johannes


More information about the Patchwork mailing list