Re: [PATCH 09/11] Optimise fetching checks when displaying a patch

2018-08-31 Thread Stephen Finucane
On Fri, 2018-08-10 at 18:01 +1000, Stewart Smith wrote: > Prior to this patch, a typical /patch// query for linuxppc-dev > (which has about half a dozen checks per patch) took around 20 queries > and 16.5ms in the database. About half of those queries were fetching > the checks and who did the

[PATCH 09/11] Optimise fetching checks when displaying a patch

2018-08-10 Thread Stewart Smith
Prior to this patch, a typical /patch// query for linuxppc-dev (which has about half a dozen checks per patch) took around 20 queries and 16.5ms in the database. About half of those queries were fetching the checks and who did the check. We can just do one query to get all that needed