[PATCH 1/2] api: do not fetch every patch in a patch detail view 404

Jeremy Kerr jk at ozlabs.org
Tue Apr 14 17:27:24 AEST 2020


Hi Daniel,

> mpe and jk and sfr found that the OzLabs server was melting due
> to some queries downloading every patch.
> 
> Turns out if you 404 the patch detail view in the API, d-r-f attempts
> to render a listbox with every single patch to fill in the 'related'
> field.

... and the query for that includes all patch content and headers, so
transferring gigabytes of data per access.

>  The bundle API also has a similar field.
> 
> Replace the multiple selection box with a text field. You can still
> (AIUI) populate the relevant patch IDs manually.

Much better, the patchwork server is no longer on fire!

Thanks for that.

Tested-by: Jeremy Kerr <jk at ozlabs.org>
Server-no-longer-on-fire-by: Jeremy Kerr <jk at ozlabs.org>

Cheers,


Jeremy



More information about the Patchwork mailing list